Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N428CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 172S8690 N428DWArizona Cloudbusters Inc · Mesa, AZBuilt 2001 · S/N 172S8708 N428EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2014 · S/N 172S11451 N428FFDhs Operations LLC · Wilmington, DEBuilt 2004 · S/N 17281228 N428RGGandolfo Air LLC · Watertown, CTBuilt 1973 · S/N 17262092 N428WREagle Flying Club Of Embry-Riddle Aeronautical Unv · Daytona Beach, FLBuilt 2005 · S/N 172S10058 N4290FRussi Kent S · Caldwell, IDBuilt 1958 · S/N 46190 N4291LRappa Giovanni · Hampton, VABuilt 1966 · S/N 17254360 N4292QSky Walker Flight School LLC · Adrian, MIBuilt 1971 · S/N 17260192 N4293LO'Hop Robert D · Jones, OKBuilt 1966 · S/N 17254362 N4293QKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1971 · S/N 17260193 N4294QOptimized Aviation Services LLC · Huntington Station, NYS/N 17260194 N4295LBravo Aviation LLC · Rexburg, IDBuilt 1966 · S/N 17254364 N4296FMargraf Todd R · Miamisburg, OHBuilt 1958 · S/N 46196 N4296LBreidenbach Todd J · Sabin, MNBuilt 1966 · S/N 17254365 N4296QAirjohn LLC · Cheyenne, WYBuilt 1971 · S/N 17260196 N4297QCritchfield David P · Paradise, CAS/N 17260197 N4298FGunn Sean · Colorado Springs, COBuilt 1958 · S/N 46198 N4298QDarrach Todd I · Rhome, TXS/N 17260198 N4299FRomano Louis A · Middletown, NJBuilt 1958 · S/N 46199 N429CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 172S8691 N429EPBbm Air LLC · Macon, GAFirst renewal noticeBuilt 2001 · S/N 17280608 N429ESBarbers Point Flight School LLC · Kapolei, HIBuilt 1997 · S/N 17280296 N429FFDhs Operations LLC · Wilmington, DEBuilt 2004 · S/N 17281229 N429LChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11452 N42APMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1977 · S/N 17269941 N42CMMazor Chris · Belleville, MIS/N 17266374 N42JAJersey Aero Club Inc · Lakewood, NJBuilt 1976 · S/N 17267383 N42LLGayden Marshall G · Wilmington, NCBuilt 1999 · S/N 172S8269 N42RLChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 17280405 N42VVSilverhawk Aviation Academy Oregon LLC · Ontario, ORS/N 172RG0703 N4300RCab Air Inc · Columbia, NJBuilt 1974 · S/N 17263054 N4301QSchneider Frederick I · Sault Sainte Marie, MIBuilt 1971 · S/N 17260201 N4301RMeggers Roger D · Baker, MTBuilt 1974 · S/N 17263055 N4302LSenn Steve E · Burwell, NEBuilt 1966 · S/N 17254371 N4303LArtic'S Air Academy LLC · Palmer, AKBuilt 1966 · S/N 17254372 N4303QHobart Aviation Inc · Akron, OHBuilt 1971 · S/N 17260203 N4304QProfessional Aviation Inc · Dalton, GAS/N 17260204 N4305LLavin Renaye K · Wasilla, AKS/N 17254374 N4306LGrandinetti Robert L · Fayetteville, NYS/N 17254375 N4307RMcmath Don · Collinsville, OKBuilt 1974 · S/N 17263060 N4308LKim Jingu · Mount Prospect, ILBuilt 1966 · S/N 17254377 N4308QN4038q LLC · Merritt Island, FLBuilt 1971 · S/N 17260208 N4309LWallace Leroy C · Wshngtn Ct Hs, OHBuilt 1966 · S/N 17254378 N4309QCamp Harold S Jr · Bossier City, LABuilt 1971 · S/N 17260209 N430CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13242 N430CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8692 N430EPFly La Wings LLC · Glendale, CAS/N 17280648 N430EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2014 · S/N 172S11453 N430FSCustom Air International LLC · Homestead, FLBuilt 1978 · S/N 17271355

Back to AD 90-06-03 R1