AD 2002-07-01
Registered aircraft · 3,466
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:2002-07-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01')
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:2002-07-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-07-01') 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.
N3976GBeauboeuf Andre F · Center Sandwich, NHN397MSGregory Wm Broburg Ltd · Minneapolis, MNN3987GParkhill Scott · Perrysburg, OHN3989GJsh Farms Inc · Hermiston, ORN3992GFlat Earth LLC · Kalispell, MTN3995GCutting Edge Design & Contracting-Sc Inc · Elgin, SCN399KMCustodio Olga · San Antonio, TXN39AKRenfro Michael W · Bethel, AKN39BEAberdeen Flying Service · Aberdeen, SDN3EM3em LLC · Karnack, TXN3KKKraussman Daniel J · San Antonio, TXN3KPAllied Asset Management LLC · Oklahoma City, OKN3LESubick Leonard W · Spring City, PAN3PZBrothers Aviation LLC · Black Rock, ARN3UFAltorfer David W · Peoria, ILN400GTDelaney Holdings LLC · De Witt, IAN401MPFriend Ships · Lake Charles, LAN401SUWright Air Service Inc · Fairbanks, AKN402MPBravan Aviation Inc · Fort Lauderdale, FLN403SWheeler James · Shreveport, LAN40DVNordstrom Eric Trustee · Anchorage, AKN40GVHauser Paul J · Longmont, CON4102LWiplinger Robert D · Inver Grove Height, MNN410ABBloxsom Allan P III · Boerne, TXN411TTRambod Marc · Taos Ski Valley, NMN412TRoberts Gregory · Scottsdale, AZN4137CN4137c Inc · Redwood City, CAN4194QJacques Jerry J · Iliamna, AKN41ARobertson Roy E · Marion, IAN41CEWhats Up Doc Aviation LLC · Alexander, ARN41YYSouthern Aircraft Consultancy Inc Trustee · Casper, WYN4216QFoulkrod Freebird LLC · Buda, TXN4226QVolatile Aero Ventures LLC · Boulder City, NVN422BWBravo Whiskey LLC · Gilbert, AZN422RKGulf Coast Aerial Mapping Co Inc · Gonzales, LAN422SWLarson Daniel · Mora, MNN4244SGolden Eagle Outfitters Inc · Delta Junction, AKN424ADSky West Aviation Inc Trustee · Albuquerque, NMN426ASSaylor Alvin N Jr · Friendswood, TXN4272QKeech Mark A · Fairbanks, AKN4291QRegistered aircraftN429DLLandset David J · West Palm Beach, FLN42CWHollywood Of The South Flight School Ltd · Decatur, GAN42WBCity Of Mesa Arizona · Mesa, AZN433BPLeverock Richard C · Port Saint Lucie, FLN439DCLaguna Sky LLC · Wilmington, DEN43AKEarth Center Adventures Inc · Haines, AKN43CPMountain View Industries LLC · Missoula, MTN43KYPinto Carlos Eduardo · Tucson, AZN43LSLima Sierra Inc · Nappanee, IN
Back to AD 2002-07-01