Registered aircraft · 68,369

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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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-04-06-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.

N2429KHarris Leritha M · Santa Cruz, CABuilt 1979 · S/N 38-79A0627 N2429MTurner Greg W · Delta Junction, AKS/N 12-1663 N2429SAdams Kelly M · Galveston, TXBuilt 1979 · S/N 18-7909148 N2429TKlassen William Peter · Davis, CABuilt 1976 · S/N 28-7690390 N242AAFf22 LLC · Scottsdale, AZBuilt 2024 · S/N 2881732 N242ABBrankov Branimir · Naples, FLS/N 0678 N242AMZike Jay N · Lindsay, CABuilt 2003 · S/N 2242 N242AVN242av LLC · Manassas, VABuilt 1972 · S/N 17260470 N242BClark Kyle B · Underhill, VTBuilt 1954 · S/N 001 N242BCElemental Aviation Lc · Wichita, KSBuilt 2011 · S/N 534-2010 N242BWLasensky David W · Newtown Square, PAS/N 10214 N242CBHarte Mike · Lone Star, TXBuilt 1978 · S/N 24-0459 N242CPBeste Robert K · Sauk Centre, MNBuilt 1978 · S/N 24-0715 N242DCRedtail Aviation Services LLC · Inglewood, CABuilt 1994 · S/N 0668 N242DFForce Dave Jr · Glenwood Springs, COBuilt 2005 · S/N 1 N242DGWing Over Aerobatics LLC · Weirsdale, FLBuilt 1995 · S/N 0687 N242DKInter Island Yachts Inc · Rncho Pls Vrd, CABuilt 1995 · S/N 0689 N242DSSneed Jason C · Spanish Fork, UTBuilt 1997 · S/N 001 N242DTSherlock William H · Greenbrae, CABuilt 1997 · S/N LRC-1 N242ENorman Brian D · Roseau, MNBuilt 1973 · S/N 17261819 N242EEOrlowski Micheal A · Gold Hill, NCBuilt 1978 · S/N 38-78A0494 N242HSpruce Creek Tiger LLC · Port Orange, FLBuilt 1977 · S/N AA5B0514 N242JMLitsky Steven H · University Place, WABuilt 1994 · S/N 0677 N242LESky King Aviation Services Inc · Ardmore, OKBuilt 1990 · S/N 1 N242LHMatthews Micheal S · Reno, NVBuilt 1994 · S/N 0673 N242LPDavenport Rebecca · Fresno, CABuilt 2000 · S/N 24340 N242MPWestwood Dave · Red Lodge, MTBuilt 1994 · S/N 0660 N242MZBechara Nizar E · Columbia, MDBuilt 1999 · S/N 0732 N242NDHaye Patrick W · Minot, NDBuilt 1999 · S/N 2842052 N242NPBa Flight Experience LLC · Margate, FLBuilt 1976 · S/N 28-7790137 N242RSPape Brandon M · Mc Gregor, TXBuilt 1997 · S/N 2054 N242SP242sp LLC · Blaine, MNBuilt 1999 · S/N 172S8226 N242STOlivier Andre · River Ridge, LABuilt 2003 · S/N 3313 N242URSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2025 · S/N 0857 N242WYHeber Huskies LLC · Salt Lake City, UTBuilt 2015 · S/N 3242 N242YAerospace Development Group Inc · Trinity, FLBuilt 2004 · S/N 40.404 N242ZMason Scott C · Lebanon, ORS/N JM-2 N24300Stater Esther F · Jerseyville, ILBuilt 1940 · S/N 1635 N24305Woolsey Joseph A · Squaw Valley, CABuilt 1977 · S/N 15280206 N2430KTylenda John R · Bigelow, ARBuilt 2005 · S/N 22712 N24312Eisenhauer Corp · Erwinna, PABuilt 1940 · S/N 1647 N24313Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15280210 N24315Cubicle Concepts Inc · New Holland, PABuilt 1977 · S/N 15280212 N2431ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1952 · S/N 22-787 N2431ESpartan College Of Aeronautics And Technology · Broomfield, COBuilt 1978 · S/N 17271280 N2431FPilot Craft Aviation LLC · Monterey, CABuilt 1979 · S/N 38-79A0437 N2431MSchroeder John · Anacortes, WABuilt 1947 · S/N 12-1675 N24323Freese Clark A · Onsted, MIS/N 1658 N24327Centurion Aviation · Salina, KSFirst renewal noticeBuilt 1977 · S/N 15280218 N2432HErsland Ryan Peter · Anchorage, AKBuilt 1979 · S/N 18-7909184

Back to AD 90-04-06 R1