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.
N45KSRentals Deltona 2 LLC · Orlando, FLN45PWEralet Inc · Middletown, DEN45WTMccarthy Brothers Aviation LLC · Albany, KYN460SRBuchman Barry Joseph · Atlanta, GAN461CDRiver City Leasing LLC · Lakeville, MNN461EDp Aviation LLC · Nixa, MON461SRRiechers Peter Trustee · Napa, CAN462CDSouth Fork Group LLC · Belmont, NCN462CPPonozzo Donald A · Plainwell, MIN462HSAmelia Ann Cruzing LLC · Sibley, LAN462PT4888 Aviation LLC · Peachtree Corners, GAN464MMeyer Brent · San Antonio, TXN464PCJordan Thomas Harvey III · Jasper, GAN465CPN465cp Partners LLC · Sugar Land, TXN466CDAsa Obion LLC · Union City, TNN466CESilver Fern Aviation Consulting LLC · Port Orange, FLN466MPMolar Air LLC · Martinez, GAN467CDStarship 1 LLC · Houston, TXN468CDSoar Above LLC · Westminster, MDN468GTTreble Teal LLC · Hood River, ORN468MBDelaware Aircraft Trust LLC Trustee · New Castle, DEN468MREastern Aerospace LLC · Wilmington, DEN469ALDudzinsky LLC · Omaha, NEN469CDRockin Robin Aviation LLC · Natchez, MSN469CPN469cp LLC · West Hollywood, CAN469FDCirrus Design Corp · Duluth, MNN469GBSale Reported · Palm Coast, FLSale reported, pending cancellationN469HHowatt Air Inc · Langdon, NDN469SRRbnt LLC · Mason, OHN46JGKslt Aviation LLC · Birdsboro, PAN46KVPigs Aviation LLC · Houston, TXN46TESerenity Aero LLC · Cape Girardeau, MON470CDPrecision Machine Tool Solutions LLC · Sinking Spring, PAN470STLima Charlie 2.0 LLC · Duluth, GAN471FDCirrus Design Corp · Duluth, MNN471WMRegistered aircraftN472CDLorton Kenneth Patrick · Brooklyn, NYN472KEB Rex LLC · East Palo Alto, CAN472MBSimmons Jeffrey F · Houston, TXN472SRJuice Club Air LLC · Palm Springs, CAN473BCWaite Aviation LLC · Xenia, OHN473BJValiair Lc Trustee · Casper, WYN473CDGrupinski Stephen · Wimberley, TXN474CCCirrus Design Corp · Duluth, MNN474CDNiagara Airways LLC · Orchard Park, NYN474PDFlying Carpet Service LLC · Wilmington, DEN474RLMassey Air Inc · Lucedale, MSN475CDBird 33 LLC · Cody, WYN476SRMjd Advisory Services LLC · Atlanta, GAN476TKAviation Partners LLC · Mcallen, TX
Back to AD 2007-24-13