Skip to content

Registered aircraft · 26,232

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N7525EJennings Shawn T · Chetek, WIBuilt 1958 · S/N 7EC-670 N7526BTyree Chris L · Arley, ALBuilt 1957 · S/N 7FC-29 N7526CTrottier Trevor · Hyde Park, VTBuilt 1958 · S/N 5641 N7526EKerlin Matthew D · Fredericksburg, VABuilt 1958 · S/N 7FC-238 N7526TJennen David · Erhard, MNBuilt 1960 · S/N 47126 N7526XWeickum Lee A · Monroe, ORBuilt 1960 · S/N 17248026 N7527TButcher Isis F · Marietta, OKBuilt 1959 · S/N 47127 N7527XRankin Scott W · Kansas City, MOBuilt 1960 · S/N 17248027 N7528BFairley Stephen M · Petal, MSBuilt 1957 · S/N 7FC-31 N7528XJewell Burton Connor Jacob · Pensacola, FLBuilt 1960 · S/N 17248028 N7529BTeck Roger M · Mayfield, NYBuilt 1957 · S/N 7FC-32 N7529GRibeiro Marcos F · Okeechobee, FLS/N 15074687 N7529U20 Awesome LLC · Albuquerque, NMBuilt 1962 · S/N 17248795 N7529XBrown Anthony W · Sacramento, KYS/N 17248029 N752DRHayden Robert P · Salome, AZBuilt 2018 · S/N 75-7571 N752MFEpperly David J · New Richmond, WIBuilt 1974 · S/N 15075977 N752TSmith Francis H Jr · Lyons, COBuilt 2012 · S/N 1015 N7530TBas Part Sales LLC · Greeley, COBuilt 1959 · S/N 47130 N7531CGregory Vernon L · Swansea, SCBuilt 1958 · S/N 5646 N7531TJanke Gregory A · Lompoc, CABuilt 1959 · S/N 47131 N7532BRimck Lloyd F · Maricopa, AZBuilt 1957 · S/N 7FC-35 N7532TVan Voast Carla J · Turner, MTBuilt 1959 · S/N 47132 N7532XRoy John L · Edmonds, WABuilt 1960 · S/N 17248032 N7533BJoe Dory Aviation LLC · Star, IDS/N 37-57 N7533GSiess Tye G · Hot Springs, ARS/N 15074691 N7533THansman Jon C · Ashland, WIFirst renewal noticeBuilt 1959 · S/N 47133 N7533XRegistration Pending · Lincoln, NDRegistration pendingBuilt 1960 · S/N 17248033 N7534BMandan Enterprises LLC · Chester, CTBuilt 1957 · S/N 7FC-38 N7534EMatta Figueroa Eduardo · Chapman, KSBuilt 1958 · S/N 7FC-243 N7534MChapman Maxwell A · Menasha, WIBuilt 1959 · S/N 55834 N7534TFreudenthal Timothy M · Wautoma, WIBuilt 1959 · S/N 47134 N7535CBerkbiegler L Allen · Lonedell, MOBuilt 1958 · S/N 5650 N7535MRegistered aircraftBuilt 1959 · S/N 55835 N7535TStearman Matthew G · Andale, KSBuilt 1959 · S/N 47135 N7535XLilley Jeffery L · Buffalo, MOBuilt 1960 · S/N 17248035 N75365Matthews John D · Land O Lakes, FLS/N 47-825 N75369Parker Jeffrey D · Chelsea, ALBuilt 1947 · S/N 47-965 N7536CCarroll Trent M · Corpus Christi, TXBuilt 1958 · S/N 5651 N7536ECheslik Michael S · Columbus, OHBuilt 1958 · S/N 7FC-244 N7536MW R Aviation Inc · Stigler, OKBuilt 1959 · S/N 55836 N7536TD&K Ag Service Inc · Lantry, SDS/N 47136 N75373Prough Steve P · Des Moines, IAS/N 47-1239 N7537CChmiel John E · Rhinelander, WIBuilt 1958 · S/N 5652 N7537EGallaway David P · Albany, ORS/N 7FC-245 N7537MKnox Larry D · Parachute, COS/N 55837 N7538TClark Walter A Jr · Willcox, AZBuilt 1959 · S/N 47138 N7538UHooper Lawrence S · Melba, IDBuilt 1975 · S/N 15077734 N7538XSpratt John G · Watkinsville, GABuilt 1960 · S/N 17248038 N7539CRandles Colt L E · Fayetteville, NCBuilt 1958 · S/N 5654 N7539EPierce Stephan L · Graham, TXBuilt 1958 · S/N 7FC-246

Back to AD 94-05-05 R1