Registered aircraft · 20,678

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.

N1129KOrange County Flight Center Inc · Santa Ana, CABuilt 2006 · S/N 172S10315 N1129MTechair LLC · Playa Vista, CAS/N 17252240 N1129USchroeder Herbert D · Plano, TXBuilt 1976 · S/N 17266858 N112APAerospace Trust Management LLC Trustee · Wilmington, DES/N 17262038 N112NBillingsley Carl · Henderson, TXBuilt 1956 · S/N 28584 N112PFEastern Kentucky University · Richmond, KYBuilt 1998 · S/N 17280400 N112PZSkymaxx Inc · Daytona Beach, FLBuilt 2005 · S/N 172S9833 N112SVGb Aviation Of Alabama LLC · Millry, ALBuilt 2003 · S/N 172S9380 N1130FMonahan William T · Vestal, NYBuilt 1966 · S/N 17254725 N1130UTc Aviation LLC · Denham Springs, LAS/N 17266859 N1132WC Flying K Aviation LLC · Savery, WYBuilt 2006 · S/N 172S10125 N1132XWest Coast Equipment Leasing LLC · Englewood, COBuilt 2006 · S/N 172S10316 N1133FFinnelly Barry J · Snohomish, WABuilt 1966 · S/N 17254728 N1133UMustachio Donald · East Stroudsburg, PABuilt 1976 · S/N 17266862 N1134FScialabba John E · Columbus, OHBuilt 1966 · S/N 17254729 N1134UWells William L · Santa Cruz, CABuilt 1976 · S/N 17266863 N1135FLong Duane C · Baskin, LAS/N 17272961 N1137FSale Reported · New Hudson, MISale reported, canceledBuilt 1966 · S/N 17254732 N1137UFoscap Air LLC · Las Vegas, NVBuilt 1976 · S/N 17266866 N1139FGifford Kenneth A · Appleton, WIBuilt 1966 · S/N 17254734 N1139UFettig Peter J · Bismarck, NDBuilt 1976 · S/N 17266868 N113AKFlight Training Aircraft LLC · Wilmington, DEBuilt 2006 · S/N 172S10182 N113BAPreston Richard R Trustee · Albuquerque, NMBuilt 1975 · S/N 17266046 N113DRCalifornia In Nice Inc · San Jose, CABuilt 1975 · S/N 17265961 N113FSHallahan Robert J · Central Square, NYBuilt 1974 · S/N 17262996 N113PFPremier Flight Center LLC · Hartford, CTBuilt 1998 · S/N 17280401 N113SVChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 172S9512 N1141MSunshine Flyers · Auburn, CAS/N 17260152 N1141UFlight School Inc · Spring, TXBuilt 1976 · S/N 17266870 N1142FHart James A · Arlington, VABuilt 1966 · S/N 17254737 N1143FWilson Dan · Saginaw, TXS/N 17254738 N1143MCastelletti Mark Anthony Trustee · Casa Grande, AZBuilt 1970 · S/N 17259443 N1144MCcr Aviation LLC · Kalispell, MTS/N 17259444 N1146FLarson Larry D · Sargeant, MNBuilt 1966 · S/N 17254741 N1147FParker Robert M · Hurst, TXBuilt 1966 · S/N 17254742 N1148FReed Roger · Lebanon, KYBuilt 1966 · S/N 17254743 N1149FLemery Aaron D · Chattaroy, WAS/N 17254744 N114FAJprg Aviation Inc · Orlando, FLBuilt 1978 · S/N 17271720 N114FBFly Appleton LLC · Appleton, WIBuilt 2005 · S/N 172S9811 N114VKKennedy Virgil C DBA · San Marcos, TXBuilt 2001 · S/N 172S8695 N114WPUniversal Aviators Academy Inc · El Monte, CABuilt 1976 · S/N 17267603 N1152MRst Aviation LLC · Vero Beach, FLBuilt 1970 · S/N 17259452 N1152ZRainier Flight Service LLC · Renton, WABuilt 2006 · S/N 172S10339 N1154GPlane Nonsense Inc · Middletown, DEBuilt 2006 · S/N 172S10126 N1154WAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10608 N1155FDejesus Rodolfo B · Murfreesboro, TNBuilt 1966 · S/N 17254750 N1157FKiss George C · Bangor, PAS/N 17254752 N1157RSale Reported · Miami, FLSale reportedBuilt 1998 · S/N 17280627 N1158FAmerican Pride Aviation LLC · Newport Beach, CABuilt 1966 · S/N 17254753 N1158QN1158q LLC · Palm City, FLBuilt 2006 · S/N 172S10354

Back to AD 90-06-03 R1