Skip to content

Registered aircraft · 1,348

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

N9264FWilson Jonathan · Natchez, MSS/N M-476 N9270SVinson Raymond R III · Mckinney, TXBuilt 1975 · S/N MC-392 N9271SLife Is A Beech LLC · Commerce City, COBuilt 1976 · S/N M-1757 N9273SYonly Abner Wanah · California, MDS/N M-1759 N9275SCole Larry G · Pigeon Forge, TNBuilt 1976 · S/N M-1763 N9276SMoody Daniel F · Lafayette, LABuilt 1976 · S/N M-1764 N9278SSpeed Kenneth W · Redington Shores, FLBuilt 1976 · S/N M-1765 N927WCalabrese Joseph Jr · Winamac, INBuilt 1979 · S/N M-2258 N9281SBmc2 LLC · Phoenix, AZBuilt 1976 · S/N M-1790 N9282SMorgan John S · Athens, ALBuilt 1974 · S/N M-1624 N9283SRegistration Pending · Johnson City, TNRegistration pendingBuilt 1975 · S/N M-1625 N9284STamad Aviation LLC · Tracy, CABuilt 1975 · S/N MC-329 N9287SDale Michael W · Clayton, NCS/N MB-758 N9289SThomsen Patrick J · Star Prairie, WIBuilt 1975 · S/N M-1651 N928ARGuluzza Gary W · Canyon Country, CABuilt 1979 · S/N M-2236 N928RJGibson Aviation LLC · Draper, UTBuilt 1976 · S/N MC385 N9290SRoss Executive Aviation Inc · Fort Smith, ARBuilt 1975 · S/N M-1627 N9295SSteadman John Harold · Santa Clarita, CABuilt 1975 · S/N M-1630 N9296SShindel Mark · Los Gatos, CABuilt 1975 · S/N MC-334 N9298SQuality Aviation Inc · Atlanta, GABuilt 1975 · S/N M-1629 N9299SSky King Flying Club Inc · Jackson, OHBuilt 1975 · S/N MC-338 N929BJNextlinq Solutions Inc · Irvine, CABuilt 1974 · S/N MC-221 N92CRWhite Nancy Ann · Queenstown, MDBuilt 1965 · S/N M-925 N9300SExcalibur Unlimited LLC · West Park, FLFirst renewal noticeS/N MC-332 N9302SLayden John M Jr · Moyock, NCS/N MB-763 N9307SRearick Scott P · Frederick, MDBuilt 1975 · S/N MC-337 N9315SBradford Alvin L · Northville, MIBuilt 1974 · S/N M-1596 N9319SMeyn Joseph · San Antonio, TXBuilt 1975 · S/N M-1652 N9322SBrungard Thomas L · Walnut Creek, CABuilt 1975 · S/N MC-342 N9324SBas Part Sales LLC · Greeley, COBuilt 1975 · S/N MC-345 N9334SFontaine & Associates Inc · Pearl, MSBuilt 1975 · S/N MC-347 N9335SKeep Climbing LLC · Las Vegas, NVS/N M-1642 N9337SDalton Stephen P · Lewistown, PABuilt 1975 · S/N M-1655 N9338SGentilin Glen R · Camino, CABuilt 1975 · S/N M-1643 N9340SGarbade Richard L · Martinez, GAS/N MC-349 N9341SSantos Eric G · West Oneonta, NYBuilt 1975 · S/N M-1644 N9344SScram Branden L · Fairbanks, AKBuilt 1975 · S/N MB-778 N9345SEvans Brian W · Laceys Spring, ALBuilt 1975 · S/N MC-355 N9346SWilson Ronald Q · Claremore, OKBuilt 1975 · S/N M-1645 N9351SHauling Ag Inc · Middlebury, INBuilt 1975 · S/N MB-769 N9354SLinda Ann Trust LLC · Dover, DES/N M-1654 N9355SBestway Pilot Car LLC DBA · Metropolis, ILBuilt 1975 · S/N M-1656 N9356SHeman Christopher M · Lees Summit, MOBuilt 1975 · S/N M-1657 N9357SWeiser Denis P · Osceola, IABuilt 1975 · S/N MC-354 N9358SAnderson Justin T · Franklin, OHBuilt 1975 · S/N M-1658 N9360SWitt Dan W · Lancaster, SCS/N M-1659 N9361SAviation Services LLC · Oshkosh, WIBuilt 1975 · S/N M-1660 N9363SDtb Holdings LLC · Cheyenne, WYBuilt 1975 · S/N MC-359 N9369SLindauer Curt C III · Belleville, ILBuilt 1975 · S/N MC-363 N9370SSheehan Robert K · Edmond, OKBuilt 1975 · S/N M-1671

Back to AD 73-20-07 R2