AD 97-01-13
Registered aircraft · 54,837
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:97-01-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13')
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:97-01-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:97-01-13') 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.
N3273EAnderson Thomas J · Big Bear City, CAN3273MLindeen Michael · Anchorage, AKN3273SHepfer John E DBA · Midland, TXN3273TSommers Bradley D · Robinson, KSN3274DMcroberts David M · Washoe, NVN3274EBitzer John · Cologne, MNN3274JOgrady John Thomas · West Chicago, ILN3274LHk Ventures LLC · Paynesville, MNN3274TRinkle Michael G · Sussex, NJN3275CMoore Hazel Grace · Boise, IDN3275DCrystoff James J · Kodiak, AKN3275LMil2atp Inc · Pikeville, NCN3276DFarkas Jonathan · Mukwonago, WIN3276SLewinsky Marlon · Carrollton, TXN3276UNk Innovations LLC · Spokane, WAN3277CSandstrom Mark R · Minot, NDN3277JBranson William E · Stokesdale, NCN3277LDeshpande Peter N · Eugene, ORN3277SBayless Smoky · Coronado, CAN3277YLapinsky Richard G · Los Lunas, NMN3278JSarrafi Frank H · Tarzana, CAN3278LPeterson Donald A · Ajo, AZN3278SStrong Brian S · Southport, NCN3278UCarver Thomas G · St Maries, IDN3278VMathison John · Vancouver, WAN3279CHunsucker Michael A · Seguin, TXN3279DDavies James E · Eagle, IDN3279LDomnarski Michael J · Ware, MAN3279MValiair Limited Co Trustee · Casper, WYN3279USchlafmann Jay R · Mercer, NDN327CTYr-Aircraft Leasing LLC · Bethel, AKN327DMMullin Clint · Lambert, MTN327HRRd Holdings LLC · Las Vegas, NVN327JKRudolph Rudi · Cordova, TNN327KMarsh John E · Washington, DCN327LSHeermann Philip D · Albuquerque, NMN327LWPerini Stephen Dale · Fayetteville, GAN327MWW. Morrison Consulting Group Inc · Aliso Viejo, CAN327TALeblanc Joseph E Jr · Houston, TXN327WLSouth Aero Inc · Albuquerque, NMN32806Nimsic Thomas L · Carson City, NVN3280LDobbertin Thomas E · Redlands, CAN3281DRichardson John David · Willis, TXN3281JRegistration Pending · Oakland, ORRegistration pendingN3281LWizna LLC · Boca Raton, FLN3281RNowicki Stanislaw · Cottonwood Heights, UTN3281SWright Flyers Club · Huber Heights, OHN3282DLafleur Kerry P · Fort Worth, TXN3282LFranco David F Jr · Santa Rosa, CAN3282SWest Thomas Edward · Watsonville, CA
Back to AD 97-01-13