Skip to content

Registered aircraft · 20,687

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N78186Johnson Gavin R · Othello, WABuilt 1968 · S/N 17257517 N7818GLippert Charles Phillip · Southwick, MABuilt 1970 · S/N 17259518 N78190Prp Aviation LLC · Ocala, FLBuilt 1968 · S/N 17257520 N78195Mishawaka Pilots Club Inc · Osceola, INBuilt 1968 · S/N 17257522 N78197Allen County Regional Airport Authority · Lima, OHBuilt 1968 · S/N 17257523 N7819GCre Aviation Holdings LLC · Ramona, CABuilt 1970 · S/N 17259519 N781BGVan Anda Aviation LLC · Apopka, FLBuilt 2000 · S/N 17280974 N781FMFmfa Inc · Wilmington, DEBuilt 1980 · S/N 17274448 N781JAPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2006 · S/N 172S10329 N781SAMeyers Terry E · Galesburg, NDBuilt 2000 · S/N 172S8599 N781SPJw Wings LLC · Midlothian, TXBuilt 2001 · S/N 172S8709 N78207Sherman Todd P · Collinsville, OKBuilt 1968 · S/N 17257526 N7820UMorris Aviation LLC · Spring Hill, TNBuilt 1964 · S/N 17251820 N7820XMassiel Galvan Grijalva Frida Trustee · Tucson, AZBuilt 1961 · S/N 17248320 N78215Alvarado Eduardo · Fayetteville, TXBuilt 1968 · S/N 17257530 N78219Testa Christopher · Kennesaw, GAFirst renewal noticeBuilt 1968 · S/N 17257532 N7821TCameron Michael Shelley · Reno, NVBuilt 1960 · S/N 47421 N78221Waldrop Floyd D · Robinson, ILBuilt 1968 · S/N 17257534 N78228Lanning Keith L · Everton, ARBuilt 1968 · S/N 17257537 N7822UKelly John K · Summerfield, NCS/N 17251822 N78239Draco Flight School DBA · Chino, CABuilt 1968 · S/N 17257540 N7823GAmerican Patrols Inc · Midland, TXBuilt 1970 · S/N 17259523 N78240Kinney Joan M · Vermillion, SDBuilt 1968 · S/N 17257541 N78242176fps LLC · Marthasville, MOBuilt 1968 · S/N 17257543 N78249Howard Ronald W · Okeechobee, FLBuilt 1968 · S/N 17257545 N7824XClampitt Kenton V · Eckert, COBuilt 1960 · S/N 17248324 N78253Chatman Hannah K · Poplar Bluff, MOS/N 17257546 N78254Bpk Holdings LLC · Montesano, WABuilt 1968 · S/N 17257547 N7825UVan Dyke Randall R · Spencer, IABuilt 1964 · S/N 17251825 N7826681 Escadrille Inc · Hutchinson, KSBuilt 1968 · S/N 17257549 N7826UDenton Aeroworx LLC · Tucson, AZBuilt 1964 · S/N 17251826 N7827TToler Gary P · San Clemente, CAS/N 47427 N7827UCook Loretta · Bel Air, MDBuilt 1964 · S/N 17251827 N7827XBarrows Carl A · Lisle, NYBuilt 1961 · S/N 17248327 N78286Marsh David J · Sioux Falls, SDBuilt 1968 · S/N 17257554 N7828TBunde Konstantine E · Goldendale, WABuilt 1960 · S/N 47428 N7828UDroz Chris G · Jamul, CAS/N 17251828 N7828XAero Smart LLC · Preston, IDBuilt 1961 · S/N 17248328 N78295Cofsky Gregory J · Sandwich, MABuilt 1968 · S/N 17257556 N78299Jb Aircraft LLC · Anchorage, AKBuilt 1968 · S/N 17257558 N7829GKilo Sierra Aviation LLC · Sammamish, WAS/N 17259529 N7829TDampier William · Greenwood, INBuilt 1960 · S/N 47429 N7829XObservation Corp · Newark, CABuilt 1961 · S/N 17248329 N782BGMt Aviation LLC · Fairbanks, AKBuilt 2000 · S/N 17280976 N782FMFmfa Inc · Wilmington, DEBuilt 1981 · S/N 17274667 N782JAAanonsen Per · Flagler Beach, FLBuilt 2007 · S/N 172S10560 N782SNKingdom Air Corps · Sutton, AKBuilt 1973 · S/N 17261341 N782WWDraco Flight School DBA · Chino, CABuilt 1997 · S/N 17280295 N78302Gardner Christopher · South Saint Paul, MNBuilt 1968 · S/N 17257559 N78303Citizen Air LLC · Port Angeles, WABuilt 1968 · S/N 17257560

Back to AD 90-06-03 R1