AD 2007-04-19 R1
Registered aircraft · 108,434
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
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N5201TOwen Richard D · Ridgecrest, CAN5201UMccrary Enterprises LLC · Port Jefferson, OHN5201VMg Aircraft Inc · Fort Lauderdale, FLN5201WStevens Wayne E II · Denver, CON5201XSims Raymond H · Navarre, FLN5201YShared Momentum LLC · Wilmington, DEN5202Fischer Robert L · Oakland, ORN52026Moore Enterprises Leasing Inc · Indianapolis, INN5202EMcdowell William R · Corpus Christi, TXN5202JLizco Aviation LLC · Jackson, MON5202NNorthern Aviation LLC · Palmer, AKN5202RHahn Douglas Keith · Waldport, ORN5202TBartella Eric A · Canastota, NYN5202WKrishna Ashwin G · Staten Island, NYN52032Briner John T · Celina, TXN52034Arq Aviation LLC · Wilmington, NCN52035Chancellor J W · Brooksville, MSN5203AGv Air Inc · Medford, ORN5203DAcumen Aerotech LLC · Rogers, TXN5203LMelnik George L · Wheeling, WVN5203NNoam Eli · New York, NYN5203PFischer Steven A Trustee · Cary, ILN5203RGehman David W · Atmore, ALN5203UHusted Robert P · Byers, CON5203XMike & Critter LLC · Mccall, IDN52048Time Flyers LLC · East Troy, WIN5204LChappell Earl W · New Cumberland, WVN5204MZenteno Nelson Jr · Winter Haven, FLN5204NN5204n LLC · Palm City, FLN5204SHildahl Gene G · Chelan, WAN5204VNimier Alexander M · Chatsworth, CAN52051Cutsforth Gary L · Palmer, AKN52055Schley James R · Palmer, AKN52057Redstone Arsenal Flying Activity · Redstone Arsenal, ALN5205BHarms Frederick L · Hesperia, CAN5205DAlleghany Flying Club Inc · Hyndman, PAN5205EGates Stephanie E · Sutton, AKN5205LPons Miguel E · Aptos, CAN5205PCope N H · Lamesa, TXN5205RValley Pilots Flying Club Inc · Martinez, CAN5205THangar 9 Inc · Aberdeen, SDN5205WAircraft 1821 LLC · North Charleston, SCN52062Rpm Inc Flying Club · South Holland, ILN52063Hattenburg Bryce R · Eagle River, AKN52065Land Air Enterprises Inc · Boynton Beach, FLN52067Rexine Jeffrey A · Chandler, AZN5206AShepherd Henry · Santa Rosa, CAN5206BStaffeldt David S · Hardwood, MIN5206LNora Jet LLC · Granbury, TXN5206PHyde Roy Wiliam · Sacramento, CA
Back to AD 2007-04-19 R1