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.
N38EPAircraft Guaranty Corp Trustee · Oklahoma City, OKN38FDCirrus Design Corp · Duluth, MNN38GWAircraft Partner N38gw Dst · BerlinN38LZJk Hangar LLC · Green Bay, WIN38MWWise Michael L · Lagrangeville, NYN38WPWjjb Aviation LLC · Fountain Hills, AZN391CPMkns 319cp LLC · Kalispell, MTN3928BKellner Eric · Upland, CAN393DSRut N Strut Aviation LLC · Shelbyville, KYN393GMFly Illini LLC · Indianapolis, INN393JM3b Family LLC · Dover, DEN394CPN394cp LLC · Pinehurst, NCN394JMHigh Steaks Aviation LLC · Ragley, LAN394MKTtc Travel LLC · Terre Haute, INN394PM394pm LLC · Ashland, VAN394SJFlinn Patrick R · Reeds Spring, MON394WTMorgan Edmund Neal · San Diego, CAN395CDSimpson Russell · Nantucket, MAN395CPVallencourt Jonathan Daniel · Green Cove Springs, FLN395LMMj&J LLC · Dodge City, KSN398MWJtde Aircraft Holdings LLC · Lebanon, OHN399DDFly Flying Buffalo LLC · Dawson, GAN39AATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN39EETamburo Michael J · Adkins, TXN39KCCapital Holdings 245 LLC · Newark, DEN39WVLojac Air LLC · Yukon, OKN3CFFlying Success LLC · Apex, NCN3LWKyllar LLC · Madison, WIN3YHMarsaudon David · Friday Harbor, WAN3ZGIsbell Tony A · Rainbow City, ALN400ARArh Aviation LLC · Gainesville, FLN400JVAero Beach Club LLC · North Palm Beach, FLN400TNSea&Air LLC · Beaufort, SCN400VTValiair Limited Co Trustee · Casper, WYN401BRBethel View Holdings LLC · Danbury, CTN401MHKenmore Crew Leasing Inc Trustee · Bellingham, WAN401TMBlue Skies Over The Creek LLC · Port Orange, FLN401TTSolomon Colors Inc · Springfield, ILN402CKEpok LLC · Wrightsville Beach, NCN402JDMqa Aviation LLC · Newark, DEN4031Panda Bear Aviation LLC · Dripping Springs, TXN403CDSma Air LLC · Lindstrom, MNN403CTCat Aviation LLC · Big Sky, MTN403PTProvo Cirrus LLC · Provo, UTN404BTMosaid Aviation LLC · Copperopolis, CAN404SGColon Aviation LLC · Greenville, SCN405CDLbi Aviation Corp · Manahawkin, NJN405SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN406CConstantine Jeffrey C · Charlotte, NCN406SRPaulus Kurt W Trustee · Delaware, OH
Back to AD 2007-24-13