AD 2007-04-19 R1
Registered aircraft · 108,434
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-04-19-R1')
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-04-19-R1')
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-04-19-R1') 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-04-19-R1') 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.
N275TBDownwind LLC · Olathe, KSN275TCQualitair LLC Trustee · MichelstadtN275TMShank Lee M · Iron Station, NCN275TXQualitair LLC Trustee · MichelstadtN275VFly Collier LLC · Naples, FLN275WYHeileman Michael P · Pewaukee, WIN275ZZWardell Robert · Montrose AuNon-citizen corporation, flight hours not reportedN2760PDickerson Gary M · Homer, AKN2760WHardin Robert S · Renton, WAN2760YSanders Flight Training Inc · Jasper, ALN2761GMartinell Justin E · Dell, MTN2761PCarlin Thomas J · N Richland Hills, TXN2761TSmith Corey J · Liberty Township, OHN2762ADorman Richard E · Mesa, WAN2762FFreflite LLC · Wilmington, DEN2762WRouth Frank D · Marion, NCN2762YFisher Global LLC · Conway, ARN27634Middaugh Terry E · Chattaroy, WAN2763FSeawings LLC · Holualoa, HIN2763TOrmsby Stephen J · Somerville, OHN2763XThompson Lyndon R · West Fargo, NDN2764JMcgregor Daniel A · Denali Park, AKN2764PBrine William R · Pahrump, NVN2764QLong Donald G Jr · Gaston, ORN2764YChennault Flying Services LLC · North Las Vegas, NVN2765FStoup Lyndal K · Cordell, OKN2765QHoney B LLC · Hillsboro, ORN2765WBriseno Anthony · Virginia Beach, VAN2765XBa Aviation LLC · Anacortes, WAN2766FBrach Raymond S · Henderson, NVN2766MDahl Jerome M · Iron River, MIN2766PMarti Larry B · Rolla, MON2766QThree Airmigos LLC · New Port Richey, FLN2767GBrowns Valley Aviation LLC · Utica, KYN2767MNew Ulm Flight Services LLC · Marshall, MNN2767PMatta Sam · Brookshire, TXN2767TCarr Jeffrey L · Hot Springs, ARN2767WMorrow Frank D · Wooster, OHN2768GCarrion John H · Colusa, CAN2768JRussell Mark Alex · Fairbanks, AKN2768TNorth Wind Aviation LLC · Chelan, WAN2768WGlenn Larry W · Bunn, NCN2768XMullett James L · Mccall, IDN2769AParish Theodore P · Anchorage, AKN2769FMatthews George W · Hillsboro, OHN2769GFraser Kevin J · Snohomish, WAN2769QPrecision Truck Equipment Inc · Lansing, ILN2769TRakhmatulin Evgeny A · Carlsbad, CAN2769WHarper Leonard D · Peyton, CON276AGSkywest Leasing Inc · St George, UT
Back to AD 2007-04-19 R1