Skip to content

Registered aircraft · 3,462

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:2002-23-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-13') 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:2002-23-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-13')
  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:2002-23-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-13')
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.

N602DNWoodley Aerial Leasing LLC · Walnut, ILBuilt 2004 · S/N 602-1127 N602THCartillar James III · Wynne, ARBuilt 2003 · S/N 602-0662 N602WFLake Air Service LLC · Jennings, LABuilt 2004 · S/N 6020684 N6034CNeal Aircraft Inc · Slaton, TXBuilt 1995 · S/N 502B-0325 N60362502 Leasing LLC · Waupun, WIBuilt 1995 · S/N 502B-0326 N6039SKorn Bruce N Jr · Grandfield, OKBuilt 1994 · S/N 502B-0256 N603DADestination Alaska Air Service LLC · Homer, AKBuilt 1957 · S/N 1161 N603WAN728ds LLC · Yakima, WABuilt 2022 · S/N 4698203 N6042SEdwards Flying Service Inc · Leland, MSBuilt 1995 · S/N 502B-0340 N60446Last Pass Aviation Inc · Humboldt, IABuilt 1995 · S/N 502B-0331 N60482Blue Earth Flying Service LLC · Blue Earth, MNBuilt 1994 · S/N 502B-0270 N60561Wbd Flying LLC · Sondheimer, LABuilt 1995 · S/N 502B-0343 N605EAChip Aviation LLC · South Pittsburg, TNBuilt 1981 · S/N LA-129 N605FCFlorida Department Of Agriculture And Consumer Svc · Tallahassee, FLBuilt 2024 · S/N 100-0346 N605JDM2driver LLC · Midland, TXBuilt 1996 · S/N BB-1555 N605PCLogan Health Medical Center · Kalispell, MTBuilt 2004 · S/N 605 N60662Aura LLC · Zeeland, MIBuilt 1994 · S/N 402A-0968 N60679Shearer John · The Dalles, ORBuilt 1996 · S/N 402B-0997 N606CMSeagull Aviation LLC · Larkspur, CABuilt 1981 · S/N LA-163 N606KAKenmore Air Harbor LLC · Kenmore, WABuilt 1954 · S/N 37 N606WCFlight Unlimited LLC · Smyrna, GABuilt 2004 · S/N 4697176 N60707Graden Aviation LLC · Polo, ILBuilt 1996 · S/N 502A-0347 N60713Lewis Flying & Maintenance Service Inc · Morse, LABuilt 1995 · S/N 502B0277 N6072XDakota Air Spray LLC · Huron, SDBuilt 1995 · S/N 502B0278 N6072YBank Of Utah Trustee · Salt Lake City, UTBuilt 1981 · S/N 0397 N6073JDukes Down Under Dusting · Ainsworth, IABuilt 1994 · S/N 502B-0250 N6078WDakota Air Spray LLC · Huron, SDBuilt 1995 · S/N 402B-0972 N60792Peniston Bob · Chillicothe, MOBuilt 1995 · S/N 502B-0280 N607MAAllen Kelvin T Trustee · Canyon, TXBuilt 2001 · S/N 4697107 N6081QPrinc Aviation LLC · Beloit, KSBuilt 1996 · S/N 402B-1001 N6082FHouston Ag Flying Service Inc · Owensboro, KYBuilt 1995 · S/N 402B-0974 N6082PAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1994 · S/N 502B-0243 N6082YDash Flying Service LLC · Chilton, WIBuilt 1980 · S/N 0273 N6083GAg Flyers Inc · Torrington, WYBuilt 1995 · S/N 502B-0284 N60877Redditt Air Service Inc · Cleveland, MSBuilt 1996 · S/N 502B-0362 N6087DTr Flying Service LLC · Milan, MNBuilt 1995 · S/N 502B-0335 N608LABear Flying Service Inc · Sicily Island, LABuilt 2010 · S/N 502B-2708 N608RHGrowers Air Service Inc · Woodland, CABuilt 2011 · S/N 502B-2737 N6097CCrop Air LLC · Eaton, COBuilt 1995 · S/N 502B-0336 N6099TAir Care Leasing LLC · Lamar, COBuilt 1993 · S/N T34-194 N60CDynamic Avlease Inc · Bridgewater, VAFirst renewal noticeBuilt 1968 · S/N LM-11 N60CNMewbourne Oil Company · Tyler, TXBuilt 1996 · S/N FL-139 N60KQTurbine Options LLC · Fishers, INBuilt 2011 · S/N 100-0060 N60LTEastern Stearman Inc Trustee · Leesburg, VAS/N 615 N60SASandbar Air LLC · Rockwood, MEBuilt 2001 · S/N FL-325 N60SBN15sb LLC · Chatham, NJBuilt 2024 · S/N 100-0350 N6102UAgri Air Inc · Chamberlain, SDBuilt 1995 · S/N 502B-0290 N6102ZGeorge'S Aerial Spraying Service Inc · Sutton, NEBuilt 1995 · S/N 502B-0293 N6105Y4j A/C Leasing LLC · Port Saint Lucie, FLBuilt 1996 · S/N 502B-0363 N6107WKubecka Jill A · Edna, TXBuilt 2015 · S/N 502B-3044

Back to AD 2002-23-13