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.
N617CPDaccarett Miguel S · Chicago, ILN617DTCacoum LLC · Boca Raton, FLN617JJAviazione Leoni LLC · Miami, FLN617LWCirrus Design Corp · Duluth, MNN617THCain Daniel · Topsail Beach, NCN6188XKorotkov Dmitry V · Rocklin, CAN618ABCss Enterprises Inc · Middletown, DEN618AJCvm Leasing LLC · Angola, NYN618ALDrifting Dirt LLC · Lewes, DEN618JABolle Aviation LLC · Clare, MIN618JLAero Venture LLC · Pasadena, CAN618JPBrown Wings LLC · Palm Beach Gardens, FLN618JRRegistered aircraftN618MBSonic Boom Services Inc · Broad Channel, NYN618VAToorani Brian B · Irvine, CAN6190LPineapple Aviation LLC · Greenville, NCN619ALLamc Associates LLC · Fargo, NDN619AWAlpha Whiskey Holdings LLC · New York, NYN619CDSimpson Walker Aviation LLC · Joplin, MON619PMDm Flying LLC · Lighthouse Point, FLN619RLPlane Addiction LLC · Hopkinton, MAN619WMKatz Aviation LLC · Riverwoods, ILN61CPFlying Df'S LLC · Dover, DEN61GEReal Estate Affiliates Of Telluride LLC · Telluride, CON61GTFogle Dennis · Pella, IAN61JMJm Airways LLC · West Palm Beach, FLN61JSAltitude & Perspective LLC · Galivants Ferry, SCN61SASierra Alpha Holdings LLC · Albany, NYN61ZPAircraft Guaranty Corp Trustee · Oklahoma City, OKN620DFCirrus Consequences LLC · Jacksonville, FLN620ECRed Fifes LLC · Coos Bay, ORN620MVLegends Air Center LLC · Bentonville, ARN620TDAct Five LLC · Moultonborough, NHN6212CJensen Consulting Service LLC · Valparaiso, INN621ARLt Dream LLC · Boerne, TXN621CFArkwell Kathy A · Peoria, ILN621FWFrancis Wayne Ltd · Springfield, OHN621KAcg Aviation LLC · Longview, TXN621RJWheels Up LLC · Ada, OKN621WYShowalter Richard L · Beckley, WVN6224WCsj Holdings LLC · Paramus, NJN622ADDoran Joe · Goliad, TXN622CCool Plane LLC · Jackson, TNN622DMRodgers Raymond S · Fredericksburg, TXN622MTDms Buffalo LLC · Buffalo, NYN622TDHjma Leasing LLC · Pinecrest, FLN623CAFast Flights LLC · Wilmington, DEN623CDVitalis Maynard · Medford, ORN623ESAerohp LLC · Cypress, TXN623SDTanner Aero LLC · Tulsa, OK
Back to AD 2007-24-13