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.
N236LLaux Air LLC · Missoula, MTN236RBCirrus Design Corp · Duluth, MNN237CGSonoma Valley LLC · Missoula, MTN237RJArgaeus LLC · Poway, CAN238ARN238ar LLC · Hickory, NCN238CARegistered aircraftN238CDHerega Mark Allen Sr · Brick, NJN238JGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN238RSPeace Transportation LLC · Harrison, TNN239RFCirrus Design Corp · Duluth, MNN23AJArcadia Aviation LLC · Milton, MAN23BCJp Saul Medical Flight Services Consulting LLC · Mount Pleasant, SCN23HCMcbride Gary · Englewood, FLN23LWGateway Air Center Inc · Merced, CAN23WHM Hixson Aviation LLC · Lake Dallas, TXN23XUTwo Three Xray Uniform LLC · Overland Park, KSN240MBFlying Brick LLC · Monroe, NCN240SRMontana Aircraft Trust Inc Trustee · Bozeman, MTN240WARight Traffic LLC · Ellenton, FLN2418NDah Aviation LLC · Boerne, TXN241CMFalgout Scott · La Place, LAN241LCD&D Air Services LLC · Mooresville, NCN241MBFlying Brick LLC · Monroe, NCN241PKAircraft Guaranty Corp Trustee · Oklahoma City, OKN241SHSky West Aviation Inc Trustee · Albuquerque, NMN241SLHickman Ira · West Richland, WAN241TBSoar47llc · Charlotte, NCN241TLAeronuts LLC · Santa Monica, CAN241TMSoaring Cessna LLC · Brookeville, MDN2428EHusel Robert · Bend, ORN242AZPs1two1 LLC · North Charleston, SCN242CABeaver Air LLC · Houston, TXN242MBRed Bird Aviation LLC · Waxhaw, NCN242SESanco Enterprises · Shoreview, MNN242SRVelocity Air Group LLC · Missoula, MTN242SVDudek David Michael · New Baltimore, MIN242TMCirco Industries LLC · Belle Chasse, LAN243CHHartz C M · Key Largo, FLN243SRNational Test Pilot School · Mojave, CAN244AHLico LLC · Cedar Rapids, IAN244EVVezzetti Eugene · Houghton, MIN244HMHuneycutt Hawell C · Mooresville, NCN244MBMunoz Santiago J · Kimberton, PAN244PVGarrett Air Holdings LLC · Mc Henry, MDN244T727 Investments LLC · Lincoln, NEN244TSCirrus Design Corp · Duluth, MNN245CPAir Jayhawk LLC · Houston, TXN245KMFm Air LLC · Wolcott, CTN245PMagruder Adam · Westcliffe, CON245WCAbsolutes LLC · Arlington, VA
Back to AD 2007-24-13