AD 2012-03-06
Registered aircraft · 69,559
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:2012-03-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-03-06')
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:2012-03-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-03-06') 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.
N103ENKjs Development LLC · Temecula, CAN103ERR & J Aviation LLC · Bloomfield Hills, MIN103FDMidnight Echo LLC · Miami Lakes, FLN103FFKnoll G C Jr · Clarendon, ARN103FPStyle Ventures LLC · Lafayette, LAN103FSHannah Lonnie · Williamson, WVN103FVChristiansen Aviation LLC · Wilmington, DEN103GLNaylor Aviation LLC · Columbia, MON103GSDuce Phillip N · Kotzebue, AKN103HMNoblett Ronald D · Bellaire, TXN103HPMcfarland Natalie · Roseburg, ORN103JGRam Aero Development Inc · Waco, TXN103KEuroaviation Inc Trustee · KematenN103KFCsa Aircraft Leasing LLC · Salt Lake City, UTN103KSKent State University · Stow, OHN103LCKenmore Crew Leasing Inc Trustee · Bellingham, WAN103LHKavalair LLC Series D · Marion, MTN103LLMoghaddas Ali · Westlake Village, CAN103LULynn University Inc · Boca Raton, FLN103MHCall One Inc · Clarinda, IAN103MK2141 Corp · Wilmington, DEN103MRDeepvine Partners LLC · Simonton, TXN103NCState Of North Carolina · Raleigh, NCN103PFQuality Protection Inc · Springfield, MON103PGHnd Operations LLC · Henderson, NVN103PZRaging Thermal Sky Sports LLC · Brighton, CON103RCSonrise Aviation LLC · Portland, INN103RGTupelo Aeronautics Inc · Tupelo, MSN103RMValiair Lc Trustee · Casper, WYN103RRLancaster Flyers LLC · Fenwick Island, DEN103SEClear Prop Aviation LLC · Sioux City, IAN103SJBarnick Air Holdings LLC · Santa Barbara, CAN103SMHermack John F · Toms River, NJN103SVSun Valley Aviation Inc · Harlingen, TXN103TNArthur Lee E · Spring, TXN103TXWilliams Bradley H Jr · Charleston, SCN103URankin Kenneth · Pinellas Park, FLN103WWWilkin Richard G · Monticello, ILN1040FMarrs Matthew D · Bentonville, ARN1040JHefferon John W · Locust Grove, GAN1040TTen Forty Tango LLC · Wichita, KSN1040UAmerican Aviation Inc · Brooksville, FLN1040VWilliamson Peter D · Houston, TXN1040WFoolish Pleasure Aviation Inc · Lewes, DEN1040ZDonnelly Jeff E · Pembroke, MAN10419C Flying K Aviation LLC · Black Hawk, CON1041CHelzer Timothy · Tucson, AZN1041GN1041g LLC · Charlotte, NCN1041HCentury Flight Systems Inc · Mineral Wells, TXN10422Jackson Benjamin Tillman · Rancho Mirage, CA
Back to AD 2012-03-06