Skip to content

Registered aircraft · 4,001

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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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:81-13-10-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.

N534MAPn4 Aviation Holdings LLC · Bishop, CABuilt 2003 · S/N 3449278 N53504Aviation Adventures LLC · Hansen, IDBuilt 1975 · S/N 33701664 N5350GSmolin Matthew R · Durango, COS/N 3449246 N53510Joey Os LLC · Darlington, PABuilt 1975 · S/N 33701670 N53519Gic Inc · Oneill, NEBuilt 1975 · S/N 33701677 N5351VHarris Adam K · Shrewsbury, MABuilt 1977 · S/N R1722292 N53520Harben Grover S III · Gainesville, GAS/N 33701678 N53525Dewind Helicopter LLC · Zeeland, MIBuilt 1976 · S/N 33701682 N5352SGustafson Steven R · Jamestown, NYBuilt 1966 · S/N 337-0452 N53531Hayes Inc · Betsy Layne, KYBuilt 1976 · S/N 33701686 N5353SBressler Lewis S · Simi Valley, CABuilt 1966 · S/N 337-0453 N53555Jewell Aviation Inc · Kennett, MOBuilt 1976 · S/N 33701698 N53573Grand Pre Gary G · Crete, ILBuilt 1976 · S/N 33701711 N53591Turtles Fly Too Inc · Boise, IDBuilt 1976 · S/N 33701727 N5359JVander Leest Roland R · Lyndon, ILBuilt 2002 · S/N 3449267 N535GWBruno Anthony · Omaha, NEBuilt 1977 · S/N 28R-7703269 N53617Holloway Walter F · Cocoa, FLBuilt 1976 · S/N 33701740 N5361RLtd Aviation LLC · Dubois, PAS/N 3449271 N53620Micren Design LLC · Yorktown, VAS/N 33701741 N53628Jacks Charles H · Anguilla, MSBuilt 1976 · S/N 33701743 N53670E&S Management LLC · Miami, FLBuilt 1976 · S/N 33701769 N53671Kennedy David C · San Diego, CABuilt 1976 · S/N 33701770 N53676N5860a LLC · Catawba, NCS/N 33701775 N5367SMedvetsky Dennis · Lincoln, RIBuilt 1966 · S/N 337-0467 N53687Gessel Todd W · Phoenix, AZBuilt 1977 · S/N 33701784 N53688Moll Jeffery A · Hubertus, WIBuilt 1977 · S/N 33701785 N53704Renforth Michael · Yorktown, VABuilt 1977 · S/N 33701795 N53708Registered aircraftBuilt 1977 · S/N 33701799 N53710High Paint Aviation LLC · Smyrna, SCBuilt 1977 · S/N 33701800 N5379WLake Park Aviation LLC · Sheboygan, WIFirst renewal noticeBuilt 2004 · S/N 1414 N5380SRoss Rexford E · Phoenix, AZBuilt 1966 · S/N 337-0480 N5382WAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 1416 N5383SScharber Patrick · Monticello, MNBuilt 1966 · S/N 337-0483 N5384Penhorwood Joshua M · Shubuta, MSBuilt 1967 · S/N R172-0238 N5384FGeipel William Robert · Woodville, WIBuilt 1976 · S/N 34-7770013 N5386SDodson International Parts Inc · Rantoul, KSBuilt 1967 · S/N 337-0486 N5387SGoyer Jeffrey A · Houston, TXBuilt 1966 · S/N 337-0487 N5392FDunn Jan D · Claremont, NHBuilt 1976 · S/N 34-7770014 N539CFAir Dorron Inc · Dayton, MDBuilt 2005 · S/N 1537 N53MKSipes Gary · Livingston, TXS/N 34-7670135 N53PLPocquette Beau W · Deer River, MNBuilt 1976 · S/N R1722171 N53SBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N 0265 N53WPRaich Aerospace Group LLC · Ormond Beach, FLBuilt 2004 · S/N 1435 N5405VVidal Aviation LLC · Gaithersburg, MDBuilt 1977 · S/N R1722294 N5406DReardon Matthew J · Henderson, NVBuilt 1975 · S/N 347570142 N540AGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1984 · S/N 28R8431025 N5418VPotters Earl C · Poreby Ok MragowoBuilt 1977 · S/N R1722296 N541ACCubillos Fernando Jose · Miami Beach, FLBuilt 1975 · S/N 347570129 N5420SLindquist Scott A · Minnetonka, MNS/N 337-0520 N5423FSkyfusion II LLC · Atlanta, GAS/N 34-7770018

Back to AD 81-13-10 R1