Registered aircraft · 1,578

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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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:72-14-08-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.

N421RMEagle Air LLC · North Myrtle Beach, SCBuilt 1969 · S/N 421A0069 N421RRBlue Star Aviation LLC · Billings, MTBuilt 1968 · S/N 4210085 N421SEQuonset Aviation LLC · North Kingstown, RIBuilt 1973 · S/N 421B0393 N421SHShepard Gregory W · Fort Myers, FLS/N 0080 N421TMEdelman Seth · Gig Harbor, WABuilt 1974 · S/N 421B0659 N421VCEr Aviation LLC · Brazil, INS/N 421B0428 N421VVTower Aviation Management LLC · Wilmington, DEBuilt 1975 · S/N 421B0959 N421WDKilo Aviation LLC · East Peoria, ILBuilt 1973 · S/N 421B0469 N421WXCeaco Inc · Las Vegas, NVS/N 421B0262 N421YPWateractive43 LLC · Auburn, CAS/N 421B0511 N421ZSale Reported · Glen Allen, VASale reportedBuilt 1968 · S/N 421-0077 N4251TJett Shelby Kerman · Pewee Valley, KYS/N 421B0533 N4266Uber Robert Eric · Pittsburgh, PABuilt 1956 · S/N 38088 N42776Hap'S Air Inc · Ames, IABuilt 1973 · S/N 421B0394 N42BCRotary Components International Inc · Houston, TXBuilt 1975 · S/N 421B0922 N42BJRegistration Pending · Oakland Park, FLRegistration pending, pending cancellationBuilt 1972 · S/N 421B0342 N42NCCapair Inc · Plantation, FLBuilt 1973 · S/N 402B0387 N42SSBas Part Sales LLC · Greeley, COBuilt 1972 · S/N 310Q0682 N42WSOrlandella Vito · Auberry, CABuilt 1955 · S/N 35143 N42YZPharaoh Aviation LLC · Velma, OKBuilt 1973 · S/N 421B0385 N431BRLockyer Roch Jr · Austin, TXBuilt 1970 · S/N 310Q0221 N432BEvans Ferguson · Washington, DCBuilt 1965 · S/N 310J0041 N433YHRegistration Pending · Stuart, FLRegistration pendingS/N 310Q0998 N440JBAg Tech Farm Services · Gamaliel, KYBuilt 1975 · S/N 421B0858 N4411TRoute 66 Aerostars LLC · Galena, KSBuilt 1959 · S/N 39024 N441DLewis Thomas F · Chico, CABuilt 1955 · S/N 35058 N4420MJohnson Capital LLC · Colleyville, TXBuilt 1973 · S/N 310Q0808 N4440KKate & Jennifer Airlines LLC · Tampa, FLBuilt 1974 · S/N 421B0567 N444ATCore Aviation LLC · Dayton, OHS/N 421B0897 N444BRNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 310H0062 N444SMPosada Law Pllc · Boca Raton, FLBuilt 1974 · S/N 421B0814 N444STPeterson Ocean Tours LLC · Pace, FLS/N 310Q0605 N444TAMiller Conner · Lake Havasu City, AZBuilt 1973 · S/N 421B0390 N44KFEbert Construction Co Inc · Wamego, KSBuilt 1974 · S/N 421B0598 N44SCAir Charter Solutions Inc · Bloomington, MNBuilt 1969 · S/N 421A0101 N4500VBales Philip J · Chandler, AZBuilt 1964 · S/N 320B0053 N4537QInstant Security Service Inc · Wilmington, DEBuilt 1972 · S/N 402B0343 N4546QHarlow Jack M · Benbrook, TXBuilt 1973 · S/N 310Q0728 N4550QIsland Wings Inc · Fort Lauderdale, FLBuilt 1969 · S/N 402A0050 N456HACeltic Air Inc · Lake City, FLBuilt 1974 · S/N 421B0614 N4572LFiegel Donald H · Ward, ARBuilt 1968 · S/N 421-0172 N458VCWing And A Prayer LLC · Sarasota, FLBuilt 1974 · S/N 421B0915 N45KPColvin Clu D DBA · Big Cabin, OKBuilt 1971 · S/N 401B0201 N465CWSkyking LLC · Lake Stevens, WABuilt 1963 · S/N 310H0134 N466QBiziorek Thomas R · Harbor Springs, MIBuilt 1972 · S/N 310Q0534 N467DMMustang Sally Aviation LLC · Camden, SCBuilt 1973 · S/N 421B0377 N468KWLance Johnson Ministries Inc · Calhoun, GABuilt 1962 · S/N 310G0058 N46941Haynes Aviation LLC · Caruthersville, MOS/N 35495 N469LCGaletti Ralph R · Albuquerque, NMBuilt 1974 · S/N 421B0627 N469TMAerostream Services LLC · Cincinnati, OHS/N 310K-0202

Back to AD 72-14-08 R1