Registered aircraft · 1,770

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:2018-03-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:2018-03-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:2018-03-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:2018-03-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:2018-03-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:2018-03-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.

N444KFSchnell Michael L · Spearman, TXBuilt 1984 · S/N 425-0191 N444LSTaa Property LLC · Lake Wales, FLBuilt 1973 · S/N 414-0460 N444SMPosada Law Pllc · Boca Raton, FLBuilt 1974 · S/N 421B0814 N444TAMiller Conner · Lake Havasu City, AZBuilt 1973 · S/N 421B0390 N4492UAircraft & Aviation Professionals LLC · Coldwater, MIS/N 421C0020 N44GAFly Qts LLC · Oconomowoc, WIBuilt 1978 · S/N 414A0036 N44KFEbert Construction Co Inc · Wamego, KSBuilt 1974 · S/N 421B0598 N44NESouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 4140070 N44SCAir Charter Solutions Inc · Bloomington, MNFirst renewal noticeBuilt 1969 · S/N 421A0101 N451AMPalm Tree Adventures LLC · Austin, TXS/N 421C0808 N4537QInstant Security Service Inc · Wilmington, DEBuilt 1972 · S/N 402B0343 N454SPSps Investment Properties LLC · Macon, GABuilt 1980 · S/N 414A0626 N4550QIsland Wings Inc · Fort Lauderdale, FLBuilt 1969 · S/N 402A0050 N456FCLamar Leasing Company · Lamar, INBuilt 1981 · S/N 425-0127 N456HACeltic Air Inc · Lake City, FLBuilt 1974 · S/N 421B0614 N456JREle Motorsports LLC · Dover, DEBuilt 1981 · S/N 425-0093 N456STMcbride Ken · San Martin, CABuilt 1975 · S/N 414-0810 N4572LFiegel Donald H · Ward, ARBuilt 1968 · S/N 421-0172 N458VCWing And A Prayer LLC · Sarasota, FLBuilt 1974 · S/N 421B0915 N459DMStafford Wings LLC · Fredericksburg, VABuilt 1981 · S/N 421C1084 N45BBSpeer Aircraft LLC · Evansville, INBuilt 1979 · S/N 421C0661 N45JRJmf Inc · St Maries, IDBuilt 1976 · S/N 421C0109 N45KPColvin Clu D DBA · Big Cabin, OKBuilt 1971 · S/N 401B0201 N4630NHyannis Air Service Inc · Hyannis, MABuilt 1978 · S/N 402C0001 N4635GN535j LLC · Bismarck, NDBuilt 1977 · S/N 414-0906 N4640GHonea Richard S · Canton, GABuilt 1976 · S/N 414-0908 N4645GAnderson Cattle Co Inc · Emporia, KSS/N 414-0913 N464DCDelta Charlie Aviation LLC · Glendale, AZBuilt 1979 · S/N 421C0709 N4666NM & P Genpar LLC · Corpus Christi, TXBuilt 1978 · S/N 414A0059 N4668NSre Holdings LLC · Dewitt, MIFirst renewal noticeBuilt 1978 · S/N 414A0061 N466CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1980 · S/N 402C0428 N466JWWf Construction Inc · La Verne, CAS/N 421C0241 N4677NLps Equipment And Acquisition Co Inc · Clarksburg, TNBuilt 1978 · S/N 414A0068 N467DMMustang Sally Aviation LLC · Camden, SCBuilt 1973 · S/N 421B0377 N4680NRentz Communications Inc · New Smyrna Beach, FLBuilt 1978 · S/N 414A0070 N4693NWade Air LLC · West Palm Beach, FLS/N 414A0079 N4698AExpress Air LLC · Wilmington, DES/N 414A0083 N469CJHerndon Aviation LLC · Kokomo, INBuilt 1980 · S/N 421C1018 N469LCGaletti Ralph R · Albuquerque, NMBuilt 1974 · S/N 421B0627 N4701AWtfa LLC · Decatur, ALBuilt 1978 · S/N 414A0085 N470BCCorvus Flight LLC · Salinas, CABuilt 1977 · S/N 414-0918 N470RKBcnbb LLC · Duncan, OKBuilt 1981 · S/N 425-0082 N471BWPatriot Environmental LLC · Meeker, OKS/N 421C0640 N471HBMyers Ralph E · San Clemente, CABuilt 1977 · S/N 414-0923 N471MASwift Aviation LLC · Decatur, TNBuilt 1979 · S/N 414A0279 N475JNMiller Aviation LLC · Carrier Mills, ILS/N 414-0917 N4763GGamma Transport Solutions Inc · Carrollton, TXFirst renewal noticeBuilt 1977 · S/N 414-0938 N4765GAircraft Charter And Leasing LLC · El Cerrito, CABuilt 1977 · S/N 414-0940 N4772ADodson International Parts Inc · Rantoul, KSS/N 414A0095 N477MGJuliet Delta Aviation LLC · Bozeman, MTBuilt 1973 · S/N 421B0477

Back to AD 2018-03-03 R1