Registered aircraft · 40,396

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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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:79-10-03-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.

N5136EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271729 N5136GYork Aviators LLC · York, PAS/N 17258450 N5136LBerkowitz Bruce · Poughkeepsie, NYBuilt 1967 · S/N 28-4419 N5136PDunn James F · Salem, INBuilt 1958 · S/N 24-150 N5136UNg Raymond Fong · New York, NYBuilt 1980 · S/N 172RG0252 N5136WGreen Patric S · Stillwater, OKBuilt 1961 · S/N 28-165 N51379N51379 LLC · Galena, OHBuilt 1974 · S/N 17264235 N5137LSky Vector LLC · Rustburg, VABuilt 1967 · S/N 28-4421 N5137MFuture Pilots Of America Flight Academy LLC · Baxley, GABuilt 1978 · S/N MB-890 N5137PFrancis Himanshu Raj · Blythewood, SCBuilt 1958 · S/N 24-151 N5137RSchmeelk Darrin D · Thompson, CTBuilt 1974 · S/N 17263354 N5137VBurns Mark G · Anacortes, WABuilt 1962 · S/N SP33 N5137WKrehbiel Timothy M · Holt, MOBuilt 1961 · S/N 28-166 N51380Aircraft Leasing Inc · Everett, WABuilt 1980 · S/N 17274305 N5138ESanders Flight Training Center Inc · Jasper, ALBuilt 1978 · S/N 17271731 N5138LFlying Gators Inc · Overland Park, KSBuilt 1967 · S/N 28-4422 N5138RBell Ornithopters Flying Club Inc · Eastlake, COBuilt 1974 · S/N 17263355 N5138SBarr Jerry L Jr · Mount Pleasant, TXBuilt 1971 · S/N 28-7125532 N51395Rush David A · El Dorado, KSBuilt 1974 · S/N 17264237 N5139EAero Techniques LLC · Binghamton, NYBuilt 1978 · S/N 17271732 N5139LBrown Robert F · Sugarloaf Key, FLBuilt 1968 · S/N 28-4423 N5139YB & B Equipment Inc · Cantwell, AKS/N 18-8038 N513DNNowakowski Donald K Trustee · Gilbert, SCBuilt 2001 · S/N 24294 N513JCMathis Joshua D · Mitchell, INS/N 01513 N513MSteuber Edward P · Erwin, TNBuilt 1969 · S/N 388 N513MSPark Brian Byung · Anaheim, CABuilt 1992 · S/N 2841347 N513PCBaklanov Sergey I · Whitestown, INS/N 1546 N513PUBrosemer Kathleen M · Sault Sainte Marie, MIBuilt 1983 · S/N 28-8316098 N513RJGurski Robert C · Lees Summit, MOBuilt 1997 · S/N 23922 N513RMRosen Larry M Trustee · Santa Barbara, CABuilt 1977 · S/N AA5B0458 N51403Remigy Mathias E · Peterborough, NHBuilt 1980 · S/N 17274308 N5140ESadosky Paul · Glendale, WIS/N 17271733 N5140GDippolito Mario M · Sherwood, ARBuilt 1970 · S/N 28-7125073 N5140QMccoy David J · Perryton, TXBuilt 1973 · S/N 17261762 N5140RAshby Artie Dale Jr · Madison, ALBuilt 1979 · S/N 172RG0041 N5140VSale Reported · Grafton, VTSale reportedS/N SP36 N5141KGilbertsville Flying Service LLC · Gilbertsville, PABuilt 1980 · S/N 17273983 N5141LEnnis Brian K · Lizella, GABuilt 1967 · S/N 28-4425 N5141RServant Air Ministries Inc · Merritt Island, FLBuilt 1974 · S/N 17263358 N5141WOldakowski Kathleen A · Owls Head, MEBuilt 1961 · S/N 28-171 N5142HThistle Richard J · Wasilla, AKBuilt 1948 · S/N 14-152 N5142LRaider Aviation LLC · Lubbock, TXBuilt 1967 · S/N 28-4426 N5142WPacific Northwest Aeronautics Inc · Port Orchard, WANon-citizen corporation, flight hours not reportedBuilt 1961 · S/N 28-172 N5143WDager Steffen M · Milan, NHBuilt 1961 · S/N 28-173 N5144RBuffalo Flying Club Inc · Ayr, NDBuilt 1974 · S/N 17263361 N5144SWorth Frank · Bakersfield, CABuilt 1971 · S/N 28-7105181 N5144VKlein Bruce R DBA · Port Allegany, PABuilt 1962 · S/N SP-40 N5144WHub City Aviation Academy LLC · Lubbock, TXBuilt 1961 · S/N 28-174 N5144XSkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843430 N5145ESierra Pacific Aviation · Willits, CAS/N 17271735

Back to AD 79-10-03 R2