AD 2012-01-11
Registered aircraft · 3,100
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-01-11')
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-01-11')
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-01-11') 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-01-11') 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.
N212DSFlying Bee Aviation LLC · Delphi, INN212LLLunch Mony LLC · Fort Worth, TXN212RNoodlebop Inc · Provincetown, MAN212RRN2u Equipment Leasing LLC · Newark, DEN212TXCirrus Design Corp · Duluth, MNN212WVKoval John S Trustee · Marysville, OHN213AGCirrus Design Corp · Duluth, MNN213ARAdelle Aviation LLC · Sacramento, CAN213CGThomas Leasing LLC · Niota, TNN213KSTenedos LLC · Tacoma, WAN213KTCirrus Middle East Inc Trustee · Wilmington, DEN213LMDavis Aircraft LLC · Sarasota, FLN214MWSouthern Aircraft Consultancy Inc Trustee · Casper, WYN214WFWathen Aviation Inc · Hilliard, OHN214ZARegistered aircraftN215AEN215ae LLC · Dover, DEN215FJOzark Machinery Transportation LLC · West Plains, MON215GPPoint To Point LLC · Missoula, MTN215JGClower Aviation LLC · Owasso, OKN215TTEcho Whiskey Charlie LLC · Midland, TXN216BDBoldmethod Air LLC · Boulder, CON216GLDvhoops Holdings LLC · Dakota Dunes, SDN216HBMorganaire LLC · Flowery Branch, GAN216SYWings Flights Of Hope Inc · Orchard Park, NYN217CTLethalairllc · Camden, DEN217JFBcd Aviation LLC · Chicopee, MAN217JKRamp Air LLC · Clayton, NCN217SKThrust Aviation LLC · George West, TXN217SYRegistration Pending · Pratt, KSRegistration pendingN217YWhisper Rock LLC · San Antonio, TXN218BJCatalina Sky Aviation LLC · San Diego, CAN218HGDesert Aviation LLC · Kingman, AZN218HLCapital Flight LLC · El Paso, TXN218RHRjh Capital Holdings LLC · Newark, DEN218RWGba Holdings LLC · Carson City, NVN218SY46u LLC · Anaconda, MTN218VBCornelius Brett · Brentwood, TNN219CTCp Air LLC · Omaha, NEN219RSCastle Peak Leasing LLC · Soda Springs, CAN219SEMid-Continental Aviation LLC · Wilmington, DEN219SYC9 Equipment LLC · Phoenixville, PAN219TWKingdom Leasing LLC · Sheridan, WYN21BQSri Flying Club Inc · Menlo Park, CAN21EUKuppinger Aviation Services LLC · Kissimmee, FLN21FKAfk Logistics Inc · Mckees Rocks, PAN21JZGolden Goose Air LLC · Incline Village, NVN21LXMojo Aircraft LLC · Lebanon, TNN21PKBreeze Air LLC · Las Vegas, NVN21UBThesan Holdings LLC · Fort Worth, TXN220CTCirrus Design Corp · Duluth, MN
Back to AD 2012-01-11