Registered aircraft · 8,863

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

N1000PJames Bond Aviation LLC · Belgrade, MNBuilt 1963 · S/N 28-1000 N1009XEnders Richard A · San Bernardino, CABuilt 1975 · S/N 28-7505194 N100EUSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2021 · S/N 28020030 N100HRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 28-4509 N100HWYale Companies LLC · Fishers, INBuilt 2025 · S/N 2881884 N100JEResearch Consultant Solutions LLC · Miami, FLBuilt 1969 · S/N 28-5489 N100MSHam Aviation LLC · Marydel, DEBuilt 1977 · S/N 28-7890186 N101HWYale Companies LLC DBA · Fishers, INBuilt 2025 · S/N 2881920 N101KWWiseman Ken L DBA · Calhoun, GABuilt 1980 · S/N 28-8016310 N101LLTribeca Aviation LLC · New York, NYBuilt 2000 · S/N 2843367 N101VPN101vp LLC · Ambler, PABuilt 1976 · S/N 28-7790131 N1024QDuroc LLC · Watertown, WIBuilt 1977 · S/N 28-7790370 N1029HRegistration Pending · Bulverde, TXRegistration pendingS/N 28-7790278 N102PFKaehr Lyle · Decatur, INBuilt 1984 · S/N 28-8490042 N1034XBlasa Randy · Bowling Green, FLS/N 28-7505198 N1036QKelley Michael · Bellingham, MABuilt 1977 · S/N 28-7716079 N103AVFlying To Infinity And Beyond LLC · Atlanta, GABuilt 1983 · S/N 28-8390084 N103SAHolman Steven R · Vero Beach, FLBuilt 1983 · S/N 28-8416012 N103TTAero Dynamics Flying Club Inc · Mulino, ORBuilt 1974 · S/N 28-7505092 N1041QSwaz Aviation LLC · Mesa, AZBuilt 1977 · S/N 28-7716081 N1041XGyllensten Scott · Guilford, CTBuilt 1975 · S/N 28-7505199 N1045Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020177 N1047MChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 2842286 N104AAMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881573 N104DHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 2881999 N104FGWilson Conrad · Bowdon Junction, GAS/N 28-7716292 N104VADulles Aviation Inc · Bristow, VABuilt 2001 · S/N 2842115 N1057XWeisenberger Thomas · Norwalk, OHBuilt 1975 · S/N 28-7505202 N1059FRandag William F Jr · El Paso, TXS/N 2843643 N105AVAbbey Air Corp · New Castle, PABuilt 1983 · S/N 28-8490012 N105DJDelta Juliet Holco I LLC · Ocoee, FLBuilt 2025 · S/N 2881910 N105HWYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 2881996 N1060TWindy Hill Farm LLC · Cochranville, PABuilt 1972 · S/N 28-7205104 N1063LWjm Aviation LLC · North Wales, PABuilt 2006 · S/N 2843644 N1067XArchey Richard L · Georgetown, KYBuilt 1975 · S/N 28-7505204 N106BCUniversidad Interamericana De Puerto Rico · Bayamon, PRBuilt 2003 · S/N 2843582 N106DJDelta Juliet Holco I LLC · Ocoee, FLBuilt 2025 · S/N 2881911 N106EMVenture West LLC · Mesa, AZBuilt 1977 · S/N 28-7790460 N106FMGroner Michael F · Hicksville, NYBuilt 1978 · S/N 28-7990199 N106HPAgain2 · San Diego, CABuilt 2003 · S/N 2843560 N1071CBmk Aviation LLC · Northampton, PABuilt 2006 · S/N 2843648 N1072XDemaagd Ross E · Middleville, MIBuilt 1975 · S/N 28-7505206 N1075RGeorgia Aviation Authority · Eastman, GABuilt 2006 · S/N 2843649 N1076QExecutive Flight Institute LLC · Murrieta, CABuilt 1977 · S/N 28-7790374 N1079YBoyer Jerry D · Monument, ORBuilt 1962 · S/N 28-118 N107MRMeriden Aviation Center LLC · Meriden, CTBuilt 1977 · S/N 28-7816251 N107NDN107nd LLC · Wilmington, DEBuilt 1989 · S/N 2841214 N1080UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020231 N1082XWhitmer Ronald N · Ellsworth, KSBuilt 1975 · S/N 28-7505207 N108HWYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 2881997

Back to AD 2005-19-20