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.
N563SMD3 Aviation LLC · Fairfield, NJN564BAF A I LLC · Marianna, ARN564BPCrhrr LLC · Riverside, CAN564FDNf Aviation LLC · Newark, DEN564JHYj Aviation LLC · Blakely Island, WAN564PMKrebs Stephen P · Houston, TXN565CPBas Part Sales LLC · Greeley, CON565SPattarini James Martin · Houston, TXN565TVCca LLC · Wellston, OKN566SRFutures Aviation Services LLC · Sunny Isles Beach, FLN567ABPiper Aviation LLC · Lewes, DEN567ATIko Aero Services LLC · Natchez, MSN567CTAvion Sr22 LLC · Schaumburg, ILN567DMAircraft Guaranty Corp Trustee · Oklahoma City, OKN567MGHay-Con Aviation LLC · Winter Park, FLN567PAS & H Aviation LLC · Beaumont, TXN567RCpk Capital Holdings LLC · Newark, DEN567SRGoal Aircrafts Corp · Orlando, FLN568SRHaney Jeffrey · Carrollton, GAN5695DVista Air LLC · Boxborough, MAN569PGSavvy Investing LLC · Greencastle, INN569SFTaylor Bruce L Jr · Irondale, ALN56AHSouthern Aircraft Consultancy Inc Trustee · Casper, WYN56APCka Investments LLC · Mcallen, TXN56BMAtlas Aero LLC · Fargo, NDN56DACirrus Design Corp · Duluth, MNN56LLLegacy Leasing Group Inc · Wilmington, DEN56PEHart Everett T · Frederick, MDN56PFLucero John · Long Key, FLN570CDDelta Zulu Air Ventures LLC · Charleston, SCN570CPAces Hangar LLC · Bentonville, ARN570WEStella Polaris LLC · Charlottesville, VAN571CDN&I Skies LLC · Leesburg, VAN572CDWaite Aviation LLC · Xenia, OHN572CPCots Partners LLC · Saint Augustine, FLN572CTDawson Aero LLC · Fayetteville, ARN572GTBcg Aviation LLC · Nashville, ARN573CDF R E Investments LLC · Enterprise, ALN573CPThib Rentals LLC · Huntington Beach, CAN573JRHispania LLC · Camarillo, CAN573SRS & S Bridge Painting Inc · Kerrville, TXN573TTHansa Capital LLC · Wilmington, DEN574CDMassingale Harold L · Lenoir City, TNN574CPLaunchpad Properties LLC · Corpus Christi, TXN574JWCirrus Design Corp · Duluth, MNN574RKHorn Aviation LLC · Hartland, WIFirst renewal noticeN574SBristol Aircraft Leasing LLC · Willoughby, OHN5754MJ & A Aviation LLC · Danvers, MAN575CDG2 Aero LLC · Chattanooga, TNN575CPHka Flying Club LLC · Hoover, AL
Back to AD 2007-24-13