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.
N30AGAlaskan Outdoors LLC · Soldotna, AKN30AKRomanski Jack · Berkeley, CAN30AMRoth Douglas D · Lincoln, NEN30AWKnox Tommy J · Lampasas, TXN30BMagill Terry K · Beach City, TXN30BKLoeppky Neal K · Seminole, TXN30BMMoore William E · Franktown, CON30CAState Of California Department Of Transportation · Sacramento, CAN30CEWren Aircraft LLC · Menlo Park, CAN30CHSale Reported · Maiden, NCSale reported, pending cancellationN30CMBoardman Air Service LLC · Henderson, NEN30CSAdams Brad A · Soldotna, AKN30CTLaidley Robert F · Erie, CON30CWBrownd Gregory H · Shallowater, TXN30DDRegenstein Jacob · San Francisco, CAN30DMNagle Derek · Ada, MIN30DSSaver Matthew S · Lebanon, TNN30DWHeffernan Michael James · Wellesley, MAN30ECVogt Timothy J · Houston, TXN30EDN30ed LLC · Carpinteria, CAN30EEEnterprises Aviation Inc · Piedmont, SDN30ERRance Cory · Moody, TXN30ETZaldivar Carlos · Miami, FLN30EWThree Zero Echo Whisky Inc · Wilmington, DEN30FATerra Ferma Inc · Wilmington, DENon-citizen corporation, flight hours not reportedN30FBBmg Aviation Leasing LLC · Bloomington, INN30FCState Alabama Forestry Commission · Florence, ALFirst renewal noticeN30FHBaldwin Jonathan B · East Boothbay, MEN30FMM20j LLC · Niceville, FLN30GHAvientur LLC · Chesterfield, MON30GSClausen Robert G · Argyle, MNN30HCKinetic Concepts LLC · Pensacola, FLN30HUDukes William R · Tallulah, LAN30JAJahawk Leasing LLC · Sugar Grove, ILN30JBBalbierer John M · Columbus, MSN30JGAdamson Don · Lonoke, ARN30JKThompson Troy L · Amarillo, TXN30JPPhilpott Connor J Ryan · Newbury Park, CAN30JSFixed Wing Holding Co Inc · Pembroke Pines, FLN30JTMatthews William P · Blacksburg, VAN30JVJasper Aviation Inc · Jasper, ALN30JXOptimal Aviation Services LLC · Visalia, CAN30KJCrist Carry R · Crete, NEN30KWWeeks Kermit A · Polk City, FLN30LERollins Robert · Gadsden, ALN30LFSignalwave LLC · Doral, FLN30LGHusky Two Associates LLC · Brookline, MAN30LNRaymon Rodherick L · Enterprise, ALN30LPDialysis Clinic Inc · Nashville, TNN30LVNorth Arkansas Aviation LLC · Paragould, AR
Back to AD 2007-04-19 R1