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.
N41MSJennings William K · Chandler, AZN41MTX2nsat Inc · Petaluma, CAN41MWWoodard Michael G · Northport, ALN41NCTiger 41nc LLC · Malvern, PAN41NHHartz Norman E · Gardnerville, NVN41NRSholy Fred · Granada Hills, CAN41PLTj Air Holdings Inc Trustee · Wilmington, DEN41PPKansas Aviation Museum · Wichita, KSN41PSGarwood Brandon A · Poland, OHN41PVBear Nathan Eugene · Cove, ORN41PWWhitehouse Thomas · Bethlehem, GAN41QBBravo Charlie LLC · Johnston, IAN41QCMark J Heistad · Covington, LAN41RDFlip-Flop LLC · Wray, CON41RHMile High Rotors Inc · Indian Hills, CON41RTVyfvinkel Frederick J · New Smyrna Beach, FLN41RVUmbricht Marc · St-PrexNon-citizen corporation, flight hours not reportedN41SContinental National Aviation LLC · Tampa, FLN41SAIntegrated Design And Supply Inc · Crystal Lake, ILN41SBBrillaud Stephen A DBA · Germantown, TNN41SGSunrise Aviation Inc · Ormond Beach, FLN41TBMarikan LLC · Strongsville, OHN41TCMentor Flight LLC · Mercer Island, WAN41TGBusch John · Chapin, SCN41THLammers Ross L · Cumming, GAN41TRBushre David N · Janesville, WIN41TTAlvis Michael Ernie · Sparta, TNN41TWFair James A · Derby, CTN41USLucas Gregory · Santa Rosa, CAN41VBVon Bevern Brian J · Overland Park, KSN41VEJrvc Transportation Inc · Boston, MAN41VKGalaxy Aviation LLC · Nantucket, MAN41VRWalker Vincent Paul · Medford, ORN41VVTurner Andrew · Orange Beach, ALN41VZCarver Co LLC · Chugiak, AKN41WBendure Mark · Overland Park, KSN41WAHackler Jeanette D · Arlington, TXN41WBEmerald City Aircraft Leasing Inc · Port Orchard, WAN41WTPremiere Aviation Inc · Concord, CAN41XPIra Ellis LLC · Jackson, TNN41YYSouthern Aircraft Consultancy Inc Trustee · Casper, WYN41ZYBailey Thomas A · Claymont, DEN4200Burdick Rich · Montrose, CON42002Kuntz Jonathan W · Yorktown, VAN42004Haskell Airport Inc · Coweta, OKN42006Thompson Jeffrey L · Scandia, KSN42007Southeastern Oklahoma State University · Durant, OKN4200BCondair Flyers Inc · Latham, NYN4200HFoss David K · Anchorage, AKN4200XLeazer Johnathon E · Ozark, AL
Back to AD 2007-04-19 R1