AD 81-07-11 R1
Registered aircraft · 733
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:81-07-11-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:81-07-11-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:81-07-11-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:81-07-11-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.
N5182JEmery & Associates Inc · Orangeville, PAN518PCJnc Holdings LLC · Mequon, WIN519SCCrockett Ryan · Veradale, WAN51APConrad Alan B · Las Vegas, NVN51CXAerodata LLC · Ann Arbor, MIN5227JSbs Partnership · Henderson, NVN5256JKamenz Donald R · Mocksville, NCN527JHTugende LLC · Montrose, CON52STWeicks Aviation LLC9634 · Cedar Falls, IAN5316JCocola Gary M · Fresno, CAN531MHigh Cotton Aero LLC · Murray, KYN5320JCorporate Air Charter Inc · Wilmington, DEN5324JSouthern Aircraft Consultancy Inc Trustee · Casper, WYN5328JKahler Automation Corp · Fairmont, MNN533CHSwenson Roger A · Pahrump, NVN533WPJacobs Aviation LLC · Mt Juliet, TNN5340GLegal Limit Motor Sports LLC · Anderson, CAN5346JCsc Delaware Trust Co Trustee · Wilmington, DEN535KWFlying Squirrel Aviation LLC · Bozeman, MTN53AUJoachim Peter · Grafton, WIN541CMAero Parts LLC · Roselle, ILN5421JPeruzzi John DBA · Los Angeles, CAN542MNKeeler Aviation LLC · Plattsmouth, NEN5432JSouthampton Wing LLC · Southampton, NYN5432MWorthington Loren D · Caldwell, IDN543DGrantham Ray · Sevierville, TNN5446GCentral Virginia Aviation Inc · North Dinwiddie, VAN5453JC L Flight Associates LLC · Bakersfield, CAN5454XKair Aviation · Parkland, FLN545MMage Aircraft Leasing LLC · San Antonio, TXN54DFSkywave Associates LLC · Spirit Lake, IAN54GSN28hb LLC · New York, NYN550SNortheast Cubs LLC · Wilmington, DEN552SSky'S The Limit Aviation LLC · Wilmington, DEN555CPFirebird Air LLC · Fulshear, TXN555TYKiefer Karl F · Spring, TXN55RBGots To Go LLC · Wilmington, DEN5655CRegistration Pending · Westford, MARegistration pendingN567CWPlane Fun Inc Tr Trustee · Snellville, GAN568TWWestray James H · Gainesville, GAN56MAMinuteman Aviation Inc · Missoula, MTN56MELuttrell Jabe · Key West, FLN5729MN5729m LLC · Coral Springs, FLN5751CRemy H Blanchaert Jr Dds Md Pa · Wichita, KSN5757CRoberts Justin · Livingston, MTN5768S3c LLC · Waukee, IAN5827MHopland Steve · Johnson City, TNN5859MJasper County Properties LLC · Jasper, TXN5868CShimomura & Co Cpas Pc · New York, NYN5870MMcdonald Brian L · Van Alstyne, TX
Back to AD 81-07-11 R1