AD 2012-10-13
Registered aircraft · 13,306
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-10-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:2012-10-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:2012-10-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:2012-10-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.
N82MVDelacerda Lucas Lane · Baton Rouge, LAN82MZN82mz LLC · Carlsbad, CAN82PHHarold Hart & Associates Inc · Tampa, FLN82SAOrange Skies LLC · Falls Church, VAN82SNImmaculate Aviation LLC · Green Lane, PAN82TAJanes Paul A · Ontario, ORN82TEAir Urology LLC · Wadmalaw Island, SCN82TRExecutive Autopilots DBA · Sacramento, CAN82VTSwan Lake Farms LLC · Greensboro, GAN82VV82vv LLC · Portland, ORN83000Gehrer Aviation LLC · Wichita, KSN8300ZWillowridge Farm · Winchester, KYN830BJElm III Operating Company LLC · Edmond, OKN830CAValiair Lc Trustee · Casper, WYN830CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYN830DSFry Craig · Carmel, INN830TDWhite And Blue LLC · Auburn, CAN830TPValhalla Partners LLC · Atlanta, GAN830TTThuen Douglas · Andover, NJN831AMSky Candy LLC · Scottsdale, AZN831AZ847cx LLC · St George, UTN831BMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN831CCEntrantek LLC · Vancouver, WAN831CDNathan Smith Ministries · Belmont, NCN831DE2000m LLC · Pooler, GAN831DWLivewire Ventures LLC · La Jolla, CAN831EDDiaz Edgar · Elmore, ALN831GETs&L Aircraft LLC · Alexandria, MNN831JBEleven Western Builders Inc · Escondido, CAN831JCLaw Office Of Jerome A Clay · Stockton, CAN831JDMartinez Alexander J · Cumberland, MEN831JWInternational Air Services Inc Trustee · Carson City, NVN831MMAmelia Aviation LLC · Fernandina Beach, FLN831RRFresh Farms Inc · King City, CAN831SGDelahoussaye Investments LLC · Leander, TXN831TAircraft Guaranty Corp Trustee · Oklahoma City, OKN831TAN831ta Inc · Port Orange, FLN831TDJdm Aviation LLC · Yorba Linda, CAN831TRJaybird Aviation II LLC · Lake Charles, LAN831TXAtx Air Ventures LLC · Kalispell, MTN831WCEpic Vibes Consulting Group Lp · Princeton, NJN831WTN831wt LLC · Centennial, CON831YHorizon Aviation LLC · Tipp City, OHN831ZHFlight Level 250 LLC · Carmel, CAN832LMScherado Kenneth · Las Vegas, NVN832PSPase Aviation LLC · Houston, TXN8338HBayviewer LLC · Sarasota, FLN8338ZNistler Ben · Bozeman, MTN833CFPilotbear Corp · Sherman, CTN833JDReading Air LLC · St Charles, IL
Back to AD 2012-10-13