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.
N3388SShaffer Barbara J · Franklin, KYN3388TKing Eric J · Zillah, WAN3388UMenard Charles H · Grand Blanc, MIN3388WTexas Wings LLC · San Antonio, TXN3388XRoth Joe D · Livingston, TXN3388YMeeks Peris M · Gardena, CAN3389DRegistered aircraftN3389EBarnfather James D · Sequim, WAN3389MRoberts Roger W Trustee · Wichita, KSN3389PLapeyrouse Charles L · Raceland, LAN3389TSmith Barry Stephen · Huntsville, ALN3389UThompson Anthony D Trustee · Rockwall, TXN3389WUniversity Of Alaska Anchorage · Anchorage, AKN3389ZTorgerson'S LLC · Ethridge, MTN338BFBravofox LLC · Indianapolis, INN338BGBowling Green Flight Center LLC · Bowling Green, OHN338BMMorton William · Darby, MTN338BSMcnabb William B · Kingsport, TNN338CALincoln Skyways Inc · Lincoln, CAN338CTAv8 Flight Assets LLC · Eden Prairie, MNN338D38 Delta Corp · Killington, VTN338ELawffer Noel J · Amboy, WAN338EEHansen Carl A · Bowie, MDN338GSSanders Flight Training Center Inc · Jasper, ALN338HCapital Holdings Fund IV LLC · Boca Raton, FLN338HPN338hp LLC · Omaha, NEN338JFElkins Quentin D · Andersonville, TNN338LMSisk Stephen A · Greenville, ILN338MAHayes & Associates Inc · Teays, WVN338MEBoulant Michael Lee Charles · Las Vegas, NVN338MGEjdeha LLC · Boston, MAN338MKNorth Star Aviation · Mankato, MNN338NEldor Industries Inc · Toledo, OHN338NAMeister Scott R · Skillman, NJN338NSElon Aviation LLC · Burlington, NCN338PMMarso Peter G · Decorah, IAN338QJones Thomas P · Quartz Hill, CAN338RATeufel Kirsi Katariina · Ontario, ORN338RVSalvini John M · San Luis Obispo, CAN338SGMaine Rock And Recycling LLC · Rollinsford, NHN338SSSieli Paul III · Griffin, GAN338TRChan John · Newport Coast, CAN338VHDevries Larry E · Pella, IAN338VXLindsey Ricky A Jr · North Pole, AKN338XMathies Art · Anchorage, AKN3390FRodgers Christian Joseph · Ormond Beach, FLN3390TTucker Lon R · East Peoria, ILN3390WClear Blue Skies LLC · Saint Paul Park, MNN3390XPrince Aviation LLC · Las Vegas, NVN3390YHead John T Jr · Port St Joe, FL
Back to AD 2007-04-19 R1