Skip to content

Registered aircraft · 25,368

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N97136Lufertarg Group Inc · Mineola, NYBuilt 1980 · S/N 24-1061 N97154Poddoubnyi Andrey Alexandrovich · Vista, CABuilt 1984 · S/N 17276160 N97163Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276161 N9716MAshton Flyers Inc · Ashton, IDBuilt 1967 · S/N 670276 N97172C P Aviation · Santa Paula, CABuilt 1984 · S/N 17276162 N9717BCeruto Jorge · Auburndale, FLBuilt 1981 · S/N 172RG0987 N9717HBullock Linda A · Shawnee, KSFirst renewal noticeBuilt 1975 · S/N 17266331 N9717QRosenberger Gregg J · Keller, TXBuilt 1975 · S/N 17265786 N9717TLehmann Peter E · Pembroke, MEBuilt 1978 · S/N 38-78A0170 N9717VTco Inc · Stanley, NDBuilt 1974 · S/N 17264484 N9718HDyer Stacey T · Jensen Beach, FLS/N 17266332 N9718MMidwest Flight Llp · Bismarck, NDBuilt 1967 · S/N 670278 N9719MJones William H · Wilmington, NCBuilt 1967 · S/N 670279 N9719VCumbie Curtis F · Fayetteville, ARBuilt 1974 · S/N 17264485 N971FMFreeway Airport Inc · Mitchellville, MDBuilt 1977 · S/N 15281185 N9720VBoobas John P · Nicholson, GABuilt 1974 · S/N 17264486 N9721HFoster Gary P · Anchorage, AKBuilt 1975 · S/N 17266334 N9721MMartin Vincent J · Nevada City, CABuilt 1967 · S/N 670138 N9722HQuad Cities Aero LLC · Bettendorf, IABuilt 1975 · S/N 17266335 N9722VTck Services LLC · Millington, MIBuilt 1974 · S/N 17264488 N9723HFlying Tigers Flight School LLC · Houston, TXBuilt 1975 · S/N 17266336 N9723MJoseph James H · Batavia, OHS/N 670283 N9724MMoody County Choppers Inc · Flandreau, SDS/N 670284 N9725MGodby Larry V · Missoula, MTBuilt 1967 · S/N 670285 N9725QWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17265787 N97266East Hill Flying Club · Ithaca, NYBuilt 1984 · S/N 17276169 N97269J&L Aviation LLC · Malta, NYBuilt 1984 · S/N 17276170 N9727MEz Air LLC · Allendorf, IABuilt 1967 · S/N 670287 N9727VDills John H · Ione, WABuilt 1974 · S/N 17264492 N972DDarcy Cathy S · Wayzata, MNBuilt 2014 · S/N 1138-2014 N972DPCrosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1969 · S/N 17258652 N972FCBlackhawk Holding Corp · Wilmington, DEBuilt 1979 · S/N 17272682 N972NCIal Corp · Lewes, DEBuilt 1971 · S/N 17259818 N972PMNp Aviation Inc · Naguabo, PRS/N 17264940 N9730VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264494 N97311Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 17276176 N97313Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276177 N9731HCreative Strategies Inc · Proctorville, OHS/N 17266339 N9731MHausaman Jeffrey S · Las Vegas, NVBuilt 1967 · S/N 670291 N9732HLand & Leave LLC · Helena, MTBuilt 1975 · S/N 17266340 N9732VSiguaw Robert E · Deming, WABuilt 1974 · S/N 17264496 N9733ACloud Dancer Aviation Inc · Deland, FLBuilt 1978 · S/N 15281329 N9733LStock Craig A · Devon, PABuilt 1986 · S/N 17276604 N9733MJc Mooney LLC · Tallahassee, FLBuilt 1967 · S/N 670293 N9733VTyler Ronald J · Martville, NYBuilt 1974 · S/N 17264497 N9734BPreston Aviation LLC · Henderson, KYBuilt 1981 · S/N 172RG0999 N9734MHaddle Eddie · Lindon, UTS/N 670294 N97358Rick Aviation Inc · Newport News, VABuilt 1984 · S/N 17276180 N9737TBayview Flying Club LLC · Milwaukee, WIFirst renewal noticeBuilt 1978 · S/N 38-78A0177 N9737VAero Equities LLC · Ventura, CABuilt 1975 · S/N 17264499

Back to AD 80-25-07 R1