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.
N42TJShark Vision LLC · Palm Harbor, FLN42ZNHuntsville Flyers LLC · Owens Cross Roads, ALN430LPDiamond D Aviation LLC · Northford, CTN431CDMother Of Perpetual Succor LLC · Villa Hills, KYN432CBAlltrade Aviation LLC · Fort Branch, INN432CDVlahos Aviation LLC · Destin, FLN433ALBowline Aviation LLC · Jupiter, FLN433CFRotormate LLC · Royse City, TXN433CPPaul Family Properties - Texas LLC · Wasco, CAN433TMChristensen Michael S · Mesa, AZN433WSAlpha Ingredients Inc · Belle Mead, NJN434CDFlycarolina LLC · Concord, NCN434KBConnecting Aviators LLC · Katy, TXN434MMMlc Aviation LLC · Inver Grove, MNN434SRMiller Richard Francis · Waxhaw, NCN434TBFlightworks LLC · Crozet, VAN435CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYN435CPNext Century Aviation LLC · Boca Raton, FLN435SRM2 Aviation LLC · Concord Township, OHN436CDSky West Aviation Inc Trustee · Albuquerque, NMN436CPAeronauncents LLC · El Paso, TXN437CWestacott Simon · Fenwick Island, DEN438CDSquibb Daniel · Xenia, OHN438PCJaml Aviation LLC · Happy Valley, ORN438SR10sm Clr LLC · Oklahoma City, OKN439NKSt Louis Aircraft Partners LLC · Saint Louis, MON43LDIrongate Aviation LLC · Raymond, NHN43TMMkt Development LLC · Venedocia, OHN440CDN440cd LLC · Williamsburg, VAN441GWEugetech LLC · Bettendorf, IAN442TTQualitair LLC Trustee · MichelstadtN443CPBank Of Utah Trustee · Salt Lake City, UTN444AHPhalanx Pc LLC · Austin, TXN444CVCloud Punchers LLC · Cary, NCN444JHCirrusly Fast J2911 LLC · Duson, LAN444MFChampagne Cruises Ltd · St Thomas, VIN444NPJc Aviation LLC · Raleigh, NCN444UJAmbush Aviation LLC · Anabel, MON444VRBarber Casey John · Visalia, CAN445CDMockingbird Wings LLC · Wilmington, DEN446BDAircraft Guaranty Corp Trustee · Oklahoma City, OKN446CPOn Eagles Wings Aviation LLC · Ponte Vedra Beach, FLN446MTValiair Lc Trustee · Casper, WYN448AMHetpath Aero LLC · Bismarck, NDN448LMKinzler William · Tierra Verde, FLN448SRAquatic Resources Management LLC · Lexington, KYN448TTScher Steven A · Sonoma, CAN449SRCline Aviation LLC · Travelers Rest, SCN449WMWissman Enterprises LLC · Lincoln, NEN44JHCirrusly Faster J2911 LLC · Duson, LA
Back to AD 2007-24-13