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.
N623SRFerx LLC · Myrtle Beach, SCN623VSJones Lloyd Val · Blanding, UTN623WMMclaughlin Mike I · Portola Valley, CAN624ABGenelle Aviation LLC · Parsippany, NJN624CDProvincial Properties LLC · Johnson City, TNN624CMJma Aviation LLC · Cincinnati, OHN624RPMaho Bay Partners LLC · Newark, DEN624RSSr22 Delta Hotel LLC · Lafayette, LAN624SRN3809 Kilo LLC · Wilmington, DEN624VAEkl Aviation LLC · Oklahoma City, OKN624WMCirrus Design Corp · Duluth, MNN625CBPowers Brothers Real Estate · Henderson, TXN625CDTurner David C · Clinton Township, MIN625TRVictor Pathways Management LLC · Newport Beach, CAN625VSHeritage Airplane One LLC · Tullahoma, TNN626FPlane Fun Inc Tr Trustee · Snellville, GAN626MTEmtac Sr20 LLC · Palm Beach, FLN626REAv Air Lease LLC · Albuquerque, NMN626SRPf Aviation LLC · Birmingham, ALN626TRWevob LLC · Thomasville, GAN627HECrinkle Aviation LLC · Indianapolis, INN627PWSattofas Air LLC · Gilbert, AZN627RGSummer Flight LLC · Selbyville, DEN627SBFeucht Chad · Fond Du Lac, WIN627SRAccurate Corp · Wilmington, DEN627VAV1 Venture Aviation Lp · Olathe, KSN627ZZWwfly LLC · San Luis Obispo, CAN628CSWiggins Glenn C · Kewadin, MIN628ECTech Aviation Inc · Daytona Beach, FLN628RMThree Three Whiskey LLC · Kennett, MON629DMLdm Logistics LLC · Orrville, OHN629LFJamestown Aviation LLC · Neenah, WIN62CHSecond Chance Wings LLC · Leander, TXN62KDRegistered aircraftRegistration pendingN62VXDunham Darin T · Meridianville, ALN630CDDanoair LLC · Easton, MDN630MDDeh Inc · Topeka, KSN630RAAb & D Custom Furniture Inc · Monee, ILN630RCLee Aviation Services Co LLC · Pensacola, FLN631BRBrady Risk Holdings LLC · Farmingdale, NYN631RJBusiness Flyers LLC · Bedford, MAN631SRBranch Leasing LLC · Paris, TNN632CDBirch Run Aviation LLC · Wayne, PAN632HGValiair Limited Co Trustee · Casper, WYN632UBWeigand James F · Auburn, MEN633BLdba LLC · Las Vegas, NVN633CDPolaris Fire Protection Inc · Port Charlotte, FLN633GEFly High LLC · Seminole, TXN633SRTippman & Dumas Aviation LLC · Fort Wayne, INN634WSun South Of Jennings LLC · Jennings, LA
Back to AD 2007-24-13