Registered aircraft · 20,687

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.

N73PPArew Aviation LLC · San Tan Valley, AZS/N 17261627 N73PWWarren John M · El Paso, TXBuilt 1971 · S/N 17259809 N73TFKlanchar Flying LLC · Benton, ARBuilt 1966 · S/N 17255638 N73WPGemini 3 LLC · Cleves, OHS/N 17268849 N7400AHarrop Brian C · Mesa, AZBuilt 1957 · S/N 29500 N7400XLandrush Construction LLC · Fairview, OKBuilt 1960 · S/N 17247900 N7402TKnox David B · Mc Arthur, OHBuilt 1959 · S/N 47002 N7402XClemson Flying Club Inc · Seneca, SCBuilt 1960 · S/N 17247902 N7403TKoehn David Scott · Orange Beach, ALBuilt 1959 · S/N 47003 N7404TRaptor Flight LLC · Fort Worth, TXBuilt 1959 · S/N 47004 N7405GStan And Amy Weyer Aircraft LLC · Punta Gorda, FLBuilt 1970 · S/N 17259105 N7405XWills Terry W · Cedar Park, TXBuilt 1961 · S/N 17247905 N7407AKremmling Flying Inc · Kremmling, COS/N 29507 N7408AJohnston Lynwood A · Anchorage, AKS/N 29508 N7409GAero Quest LLC D/B/A · Olive Branch, MSBuilt 1970 · S/N 17259109 N7409TJohnson Scott E · Wausau, WIS/N 47009 N740DAb Prop Plane II LLC · Metairie, LABuilt 2017 · S/N 172S12070 N740SPJet Air Inc · Iowa City, IABuilt 2000 · S/N 172S8671 N7410TLepinsky Donald J · Whitehall, MTBuilt 1959 · S/N 47010 N7411ACoverdill Robert E · Savoy, ILBuilt 1956 · S/N 29511 N7411TMcbain Sarah R · West Warwick, RIBuilt 1959 · S/N 47011 N7411XTakagi Mark A · Richland, WABuilt 1960 · S/N 17247911 N7412TDavis Tonya · Hohenwald, TNBuilt 1959 · S/N 47012 N7412XEpperson Gregory R · Grove, OKBuilt 1960 · S/N 17247912 N7413TThompson Daniel L · Malta, OHBuilt 1959 · S/N 47013 N7414AMutter Wilson T · Chelan, WABuilt 1956 · S/N 29514 N7415ASmith Kevin L · Peachtree City, GABuilt 1956 · S/N 29515 N7415KClarke Kenneth J · Anchorage, AKS/N 17259115 N7415XKeenan James F · Neenah, WIBuilt 1960 · S/N 17247915 N7416AAce Flying Co LLC · Wichita, KSBuilt 1956 · S/N 29516 N7416GDreggors David Richard · Altamonte Springs, FLBuilt 1970 · S/N 17259116 N7416TMcalister Donald F Jr · Munith, MIBuilt 1959 · S/N 47016 N7416XHarris Terrence J · Killeen, TXBuilt 1960 · S/N 17247916 N7417AKoons Bill R · Centerville, MOBuilt 1956 · S/N 29517 N7417TMcgrath William F Jr · Nantucket, MABuilt 1959 · S/N 47017 N7417XNix Renford R · Lake Village, ARBuilt 1960 · S/N 17247917 N7418TDavis Larry M · Waleska, GABuilt 1959 · S/N 47018 N7419ACliff Lloyd B · Hemet, CABuilt 1957 · S/N 29519 N7419GFlycarolina LLC · Concord, NCBuilt 1970 · S/N 17259119 N7419TIntellipix LLC · Cambridge, MDBuilt 1959 · S/N 47019 N7419XSkyranch Knoxville Youth Inc · Knoxville, TNBuilt 1960 · S/N 17247919 N741DPPleasant Aviation LLC · Mount Pleasant, TXBuilt 1974 · S/N 17264611 N741GSReform Friendly Flyers LLC · Buhl, ALBuilt 1970 · S/N 17259111 N741WBEastern Kentucky University · Richmond, KYBuilt 2015 · S/N 172S11571 N7420GKellum Richard A · Seattle, WABuilt 1970 · S/N 17259120 N7420XGreen Harold J · Spokane Valley, WAS/N 17247920 N7421AHarris David C · Ventura, CABuilt 1956 · S/N 29521 N7421GLibby Matthew P · Castle Hill, MEBuilt 1970 · S/N 17259121 N7421TCostello Charles E · Greenfield, ILBuilt 1959 · S/N 47021 N7422ABeardsley Albert R · Byrdstown, TNBuilt 1957 · S/N 29522

Back to AD 90-06-03 R1