AD 2000-06-01
Registered aircraft · 39,302
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:2000-06-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:2000-06-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:2000-06-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:2000-06-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.
N1185CSturtevant Roger C Jr · The Villages, FLN1185FClements Michael R · Gig Harbor, WAN1185MOwen Steve · White City, ORN1185TBelanger Ernest E · Wasilla, AKN1186FLaclef Zebulon S · Leon, KSN11873French Justin T · Broken Bow, NEN11876Evans Ashley Eugene · Elizabeth, CON1187CNc Aviator LLC · Fuquay Varina, NCN1187MMorgan Donald F · Reno, NVN1187UNiderost Greg · Ukiah, CAN11880Carbaugh Nicholas C · Seattle, WAN11883Bedell Samuel G · Fairbanks, AKN11886Thompson Strawberry Farm Inc · Bristol, WIN1188FHumphrey Rex B · Bonney Lake, WAFirst renewal noticeN1188MTrim Tab LLC · Fort Collins, CON1188NLll Aviation LLC · Durango, CON1188UAurotel Aviation Inc Trustee · Wilmington, DEN11891Livesay Gregory K · Mc Kinney, TXN11892Virani Sohail · Euless, TXN11893Cowand II Jerry H · Merry Hill, NCN11896Mcginty Flying Service LLC · Jones, LAN11899Mccrigler Luke N · Fortuna, CAN118ARegistration Pending · Shasta, CARegistration pendingN118HRDieschbourg Thomas Arthur · Glenview, ILN118PCCarenbauer Paul J · Hernando, FLN118RABroken Aero Inc · Dunnellon, FLN118RSMc Namara William M · Rancho Cucamonga, CAN118SCLeathers Charles M · Silverthorne, CON118SGWilt Jared · Gardners, PAN118SSSoutheastern Oklahoma State University · Durant, OKN11906Rodriguez Jose · Los Angeles, CAN11907Housatonic Flying Club Inc · Danbury, CTN11909Weaver Craig A · Pickerington, OHN1190FDonnelly Patrick J · Tupper Lake, NYN1190MDorr Daniel B · Locust Grove, GAN1190QBritell Andrew Paul · Sandwich, NHN11910Destefano Dennis C · New Port Richey, FLN11913Sharkey Peter T · Providence, RIN1191CZerfas Gary B · Rockwall, TXN1191FStopa Gary · Florida, NYN1191MMoore John S · Tracy, CAN1191QCameron Schoessler Aviation LLC · Bliss, IDN1191UFlitepro Inc · Murrieta, CAN1191VWilmarth Rebecca C · Red Devil, AKN11927Omlid Robert · Watford City, NDN1192MGaruda Aviation Inc · Miami, FLN11935Legacy Pilot Training LLC · Annandale, MNN11936West Yayoi M · Sonoma, CAN11937Rdt Aviation LLC · Trumbull, CTN11938Johnson William L · Middleburg, VA
Back to AD 2000-06-01