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.

N893012265 LLC · Mercer Island, WABuilt 1978 · S/N 15282706 N89310Kuyl Marinus D · Forest Grove, ORBuilt 1978 · S/N 15282708 N89312Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282710 N8931VAeroventures 8 LLC · Mt Carmel, TNS/N 17264288 N8932VEverett William M · Tuscumbia, ALBuilt 1974 · S/N 17264289 N89333Chapel Hill Flying Club Inc DBA · Sanford, NCBuilt 1978 · S/N 15282717 N8934VUniversal Aviators Academy Inc · El Monte, CABuilt 1974 · S/N 17264291 N89358Redstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N 15282724 N89359Mccartney Robert · Mountain View, CABuilt 1978 · S/N 15282725 N89372Rodriguez Devin · Arlington, TXBuilt 1978 · S/N 15282729 N89377Bishops' Ltd · Virginia Beach, VABuilt 1978 · S/N 15282732 N8937VCowden Steven B · Bellingham, WABuilt 1974 · S/N 17264294 N89390Nevill Jordan J · Ukiah, CABuilt 1978 · S/N 15282734 N893BWLahbak Enterprises LLC · Hilton Head Island, SCBuilt 1980 · S/N P21000498 N894Blanton Aircraft Co Inc · Orlando, FLFirst renewal noticeBuilt 1968 · S/N 17257119 N8941VSky Castle Aviation LLC · New Castle, INBuilt 1974 · S/N 17264298 N8942VPilots Flying School LLC · Englishtown, NJS/N 17264299 N89430Flabob Airport LLC · Jurupa Valley, CAS/N 15282741 N89433Chapel Hill Flying Club Inc · Sanford, NCBuilt 1978 · S/N 15282743 N89438Sun Aircraft Management LLC · Ormond Beach, FLBuilt 1978 · S/N 15282747 N8943VZiegler Aviation LLC · Minneapolis, MNBuilt 1974 · S/N 17264300 N8944Bundy John F · Hamilton, MTBuilt 1973 · S/N 608-74 N89456Czyzewski Justin · East Brunswick, NJBuilt 1978 · S/N 15282755 N8946Cox Paul Bartlett · Granbury, TXBuilt 1973 · S/N 407-74 N89464Freeway Airport Inc · Mitchellville, MDBuilt 1983 · S/N 17276006 N89469Hershberger David A · Unionville, INBuilt 1978 · S/N 15282759 N8946VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17264302 N8947VMills Alan F · Chatom, ALBuilt 1974 · S/N 17264303 N8948VPlain Company Ltd · Bloomfield Hills, MIBuilt 1974 · S/N 17264304 N89503Menne Aviation LLC · Brooklyn Park, MNBuilt 1983 · S/N 17276007 N89531Glynco Manning Aviation Inc · Brunswick, GABuilt 1978 · S/N 15282771 N89533Ashby Shawn Alan · San Luis Obispo, CABuilt 1978 · S/N 15282773 N89539Jkg LLC · Murfreesboro, TNBuilt 1978 · S/N 15282775 N89549Jodkin Jason J · Confluence, PAFirst renewal noticeBuilt 1978 · S/N 15282781 N8956Martini Philip D · Bethel Park, PABuilt 1973 · S/N 123-74 N8957VN8957v LLC · Fort Lauderdale, FLBuilt 1974 · S/N 17264313 N8958English John H · Pittsburg, TXBuilt 1973 · S/N 610-74 N89585Vinland Flight School LLC · Topeka, KSBuilt 1978 · S/N 15282796 N89588Jet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N 15282797 N8958VHyldburg Aviation Inc · Plymouth, MABuilt 1974 · S/N 17264314 N89594Executive Aviation LLC · Peoria, AZBuilt 1983 · S/N 17276009 N89600Philbrick Rodney C DBA · Bishop, CABuilt 1978 · S/N 15282801 N8961VHampton Flying Services LLC · Portsmouth, NHBuilt 1974 · S/N 17264317 N8961ZHein-Reece Linda K · Shelton, WABuilt 1973 · S/N 17262110 N896482fly-Safety LLC Trustee · Azle, TXBuilt 1977 · S/N 15282816 N8964VOneill Jared · Gilroy, CABuilt 1974 · S/N 17264320 N89652Lexington Flying Club Inc · Lexington, KYBuilt 1978 · S/N 15282819 N89653Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282820 N89661Kelly William W · Springfield, ORBuilt 1978 · S/N 15282821 N89664Mulligan James Michael Trustee · Mesa, AZBuilt 1978 · S/N 15282822

Back to AD 80-25-07 R1