AD 2007-24-13
Registered aircraft · 4,026
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-24-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:2007-24-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:2007-24-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:2007-24-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.
N505PTBeckett Consulting Services Inc · Fort Collins, CON5060VMacair Aviation LLC · Xenia, OHN506CPHunter Mechanical & Controls Inc · Oklahoma City, OKN506LMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN506PGPegasus Air LLC · Westerville, OHN507CPFrom The Ground Up Air LLC · Lake Havasu City, AZN507KBTj Air Holdings Inc Trustee · Wilmington, DEN507MCBowden Wayne · Draper, UTN5084VAerospace Trust Management LLC Trustee · Wilmington, DEN508DKTravel Express Aviation LLC · West Chicago, ILN508JBJuliet Bravo LLC · Olathe, KSN508JDSterling Aviation Group LLC · Colorado Springs, CON508RASouthern Aircraft Consultancy Inc Trustee · Casper, WYN508WHBas Part Sales LLC · Greeley, CON509CDTfs Limited LLC · Scarborough, MEN509CETitle Associates LLC · Hurricane, UTN509CMKuppinger Aviation Services LLC · Kissimmee, FLN509CPWalsh Jacob R · Tucson, AZN509RRAlten Flight LLC · Northbrook, ILN509WFCirrus Design Corp · Duluth, MNN50BVStrickland H Len Jr · Fairhope, ALN50FTN50ft LLC · Boca Raton, FLN510CDMcgraw Jon W · Sitka, AKN511ATCirrus Design Corp · Knoxville, TNN511BJohnson Brian P · Baileys Harbor, WIN511CDTailwinds Aviation LLC · New Orleans, LAN511SEBaehr Michael C · Hernando Beach, FLN511SRHunter John D · Alamo, CAN5123YDillon William · Corvallis, ORN512APArcrft Sr2x LLC · Ashburn, VAN512AWAir Ware Leasing LLC · Austin, TXN512CDRns Management Holdings LLC · Naples, FLN512CPCore Aviation LLC · Dayton, OHN512HJN512hj LLC · Miami, FLN512TRFox And James Inc · Latrobe, PAN513SROdan Aero LLC · Alpharetta, GAN513TWGabriel Aviation LLC · Jacksonville, FLN513WCayuga Aviation LLC · Ithaca, NYN513XFarina Paul A · Liberty Twp, OHN513ZPlain Nuts LLC · Dover, DEN5147YN5147y LLC · Andover, MNN514BRJmb Aviation LLC · Iowa City, IAN514DTNorth Shore Aviation Inc · Merrick, NYN514EDFarris Stephen L · Hickory, NCN514SMEleven Eleven Aviation LLC · Rockwall, TXN514SRHarbor Aviation Ltd · Camarillo, CAN515MHWindward Aviation Corp · Santa Clara, CAN515SCLinden Aviation LLC · Naples, FLN515SMApres Logistics LLC · Missouri City, TXN516CPJohnson David A · Belvidere, IL
Back to AD 2007-24-13