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.
N711KDDelta Kilo Mike LLC · Rayville, LAN711KRMi Leasing LLC · Knoxville, TNN711KWCrosswind Aviation Ltd · Wilmington, DEN711QTTax Law Offices Of David W Klasing Pc · Irvine, CAN711XXJci Leasing LLC · Moultrie, GAN712ATWegner Cole Aviation LLC · Lincoln, NEN712CDLamadera Enterprises LLC · Lufkin, TXN712MBZero 24 Interests LLC · Houston, TXN712RALone Mountain Aircraft LLC · Vandalia, OHN712RMCrown H Cirrus LLC · Casscoe, ARN712RXWhiskey Kilo LLC · Monroe, LAN712SCKilo-Seven Aviation LLC · Annapolis, MDN71357Horn Associates 2 LLC · Brookline, MAN713CDCamoin Robert J II · Suffield, CTN713GGLomi Aviation LLC · Houston, TXN713RDGrow Rich LLC · Wilmington, DEN713SBAnderson Adam Lee · Loomis, CAN713SRMike & Matts Plane LLC · Brooklyn, NYN715CDRegistered aircraftSale reportedN715CRCrv Aviation LLC · Palmetto Bay, FLN715EMCloud 9 Aviators LLC · Lake Zurich, ILN715JGBz Air LLC · Lebanon, NJN715JNHerman David Trustee · Chesapeake, VAN715JPSk Air LLC · Federalsburg, MDN715LPN715lp LLC · Sarasota, FLN715MHHill Michelle · Yreka, CAN715RLNofziger Medical Consulting LLC · Stryker, OHN715SRSch Aviation Inc Trustee · NorfolkN715WTAscend Amigos LLC · Alpine, WYN715YAKansas Aviation LLC · Lawrence, KSN715YJQuintet Capital LLC · Marysville, OHN716BLMcl Aviation LLC · Pinehurst, NCN716BSOz Fund Investments LLC · Charleston, WVN716CDSky-Vu Flyers Inc · Fishers, INN716DRT A S K Aviation LLC · Panama City Beach, FLN716JDMyers Drew E · Norton, MAN716KPSpirit Travel Air LLC · Saint Charles, MON716PVOptimum G7 Aviation LLC · Sterling, VAN7171XUnion Hill Aviation Inc · Wilmington, DEN717AHGrace By Air LLC · Hogansville, GAN717APLone Mountain Aircraft LLC · Vandalia, OHN717BGRye Aviation Services LLC · Palm City, FLN717DFSb Aviation Corp · New York, NYN717EGHeritage Leasing Inc · Albertville, ALN717JB737 Cessna Inc · Naples, FLN717PGMc Consultants LLC · Isle Of Palms, SCN717SUMouki Aviation LLC · South Lake Tahoe, CAN717VMTir Holdings LLC · Safety Harbor, FLN717WHCelebrity Aviation LLC · Tupelo, MSN717ZStephanie Air LLC · Chester Springs, PA
Back to AD 2007-24-13