AD 84-10-01 R1
Registered aircraft · 20,483
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N43TBAndreu Kenneth · Valhalla, NYN43TJCyr Philip · Charlton, MAN43VRMountain Ridge Aviation LLC · Millersburg, PAN4400CLange Marc B · Spokane Valley, WAN4401CAsher Mitchell J · Senoia, GAN4402CMclain Daniel E · Baden, PAN4402JBruton Paul · El Campo, TXN4403CArlins Aircraft Service Inc · Belgrade, MTN4405CDavis Richard L · Everett, WAN4406RDe Nora Christian G · San Antonio, TXN4408CBarron Aviation LLC · Perry, MON4411CBartko Ramon · Pittsburg, TXN4413CSteele Aviation Inc · Walnut Cove, NCN4414CJohnson Thomas W · Westminster, MDN4414RKirk Ledoux · Stanwood, WAN4415CHunter Mason B · Helena, MTN441NAHendry Rickey W · Apple Springs, TXN441SPPendragon Aviation LLC · Sylvania, GAN441TJRylee LLC · Lawrence, KSN4420CMilton William H · Amsterdam, NYN4421CLake City Aero Ltd LLC · Grenada, MSN4421UClaypool James W · Hunts Point, WAN4423RAviation Specialists Inc · Gonzales, LAN4424CCollard Mark · Montague, MIN4425CShipman Jared K · Bismarck, MON4426CAllen Stephen W · Fredericksburg, TXN4427C28 North Plus LLC · New Smyrna Beach, FLN4428DJst Management LLC · Zephyrhills, FLN4429ETwo Niner LLC · Portola Valley, CAN4429LShingebiss LLC · Independence, ORN442GRAk Air Leasing LLC · Homer, AKN442LHSkylane 182q LLC · Punta Gorda, FLN442RAKing Air Properties LLC · Huntington Beach, CAN442SSN442ss LLC · Middletown, OHN4430CAltitude Partners LLC · Louisburg, NCN4431VPeters Frank S · Aspen, CON4432CC & J Aviation Of Arkansas LLC · Flippin, ARN4434CNewberg Edgar T · Hector, MNN4434KAzar Abdo Georges · Houston, TXN4438CCiabattoni Joseph L · Upland, CAN4439CRegistration Pending · Wilmington, DERegistration pendingN4439QLipan Creek Flying Serice LLC · Eola, TXN443KAKirsch John P · Fort Defiance, AZN4441WHodge Henry D Jr · Anchorage, AKN44441Breeden William N · Gaithersburg, MDN4444CLester Chad M · New Castle, DEN4444TKinzie Industries LLC · Alva, OKN4444WKoehler Robert E · West Lafayette, INN4447RManos Con Alas Ministries · Sierra Madre, CAN4448CSnider Gary · West Des Moines, IA
Back to AD 84-10-01 R1