Skip to content

Registered aircraft · 20,683

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.

N2635LQueen Matthew E · Shenandoah, VAS/N 17255835 N26379Wings Over Texas Holdings LLC · Denton, TXBuilt 1998 · S/N 17280573 N2637LAustin Timothy · Abbeville, SCBuilt 1967 · S/N 17255837 N2637UMarks Charles A III · Apalachicola, FLBuilt 1963 · S/N 17250237 N2638LMorgan Todd W · Roscoe, ILBuilt 1967 · S/N 17255838 N263EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13503 N263SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13406 N2640USealey Gary W · Saint Pauls, NCBuilt 1963 · S/N 17250240 N2641LTm Aviation Services LLC · Riverside, CABuilt 1967 · S/N 17255841 N2642LRiggin Flight Service Inc · Madison, SDS/N 17255842 N2642QLongerbone Danny L · Fishers, INBuilt 1970 · S/N 17258931 N2643UGaring Gerald R · Schenectady, NYBuilt 1963 · S/N 17250243 N2645LMchugh Eric P · Cleveland, TXS/N 17255845 N2646UEarly Patricia A · Palmyra, PABuilt 1963 · S/N 17250246 N2647LCommonwealth Aviation Services LLC · Herndon, VABuilt 1967 · S/N 17255847 N26481Accessible Aviation Inc · Tupelo, MSBuilt 1998 · S/N 17280578 N2648LZangs William J · Poplar Grove, ILBuilt 1967 · S/N 17255848 N2648URock Kenneth L · Petersburg, AKBuilt 1963 · S/N 17250248 N26499Advanced Aviation Group LLC · Frederick, MDBuilt 1999 · S/N 17280730 N2649JN2649j LLC · Palm City, FLBuilt 1998 · S/N 17280599 N2649UMorrison Kent · Mccleary, WAFirst renewal noticeBuilt 1963 · S/N 17250249 N264CAChoice Aviation LLC · Hamilton, MTBuilt 1975 · S/N 17266035 N264CTDouglass Joyce M · Christiansburg, VABuilt 1978 · S/N 17270716 N264EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13504 N264SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13407 N26502Bugsmasher Aviation LLC · Benton, KSBuilt 1998 · S/N 17280600 N26504Vista Aviation Inc · Pacoima, CABuilt 1998 · S/N 17280601 N2650LRholetter Eric W · Westminster, SCBuilt 1967 · S/N 17255850 N2651LJohnson Turner C II · England, ARBuilt 1967 · S/N 17255851 N2651RAtls Aviation LLC · Stuart, FLBuilt 1998 · S/N 17280542 N2652LSullivan James M · East Wakefield, NHBuilt 1967 · S/N 17255852 N2653UClark Nikita C · Ontario, ORS/N 17250253 N2654LGriner Carrie L · Auburndale, FLBuilt 1967 · S/N 17255854 N2656GAtp Aircraft 4 LLC · Wilmington, DEBuilt 1998 · S/N 17280569 N2656LSzymanski Alexander G · Hernando, MSBuilt 1967 · S/N 17255856 N2657USzymanski Janet M · Alanson, MIBuilt 1963 · S/N 17250257 N265ERAerosolutions Group Inc · Wilmington, DEBuilt 1976 · S/N 17268081 N265SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13409 N2661LHall David B Jr · Midland City, ALBuilt 1967 · S/N 17255861 N2661UMoret Ronald P · Los Osos, CABuilt 1963 · S/N 17250261 N2662LWaller Leslie P · Cynthiana, KYBuilt 1967 · S/N 17255862 N2662UDeal Sarah M · Saint Joseph, MIBuilt 1963 · S/N 17250262 N26630Iasco Flight Training Inc · Redding, CABuilt 1998 · S/N 17280565 N2663UBas Part Sales LLC · Greeley, COBuilt 1963 · S/N 17250263 N2663XAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280643 N2665LKay Bennie L · Brigham City, UTBuilt 1967 · S/N 17255865 N2666URegistration Pending · Decatur, TXRegistration pendingBuilt 1963 · S/N 17250266 N2668LEnnis Shannon E · Chesapeake, VABuilt 1967 · S/N 17255868 N2668UMid South Aircraft Inc · Gadsden, ALBuilt 1963 · S/N 17250268 N2669LRotormate LLC · Royse City, TXBuilt 1967 · S/N 17255869

Back to AD 90-06-03 R1