AD 84-10-01 R1
Registered aircraft · 20,481
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.
N5572BOrcutt David R · Greenleaf, IDN5574BEyler Keith Michael-Wayne · Menifee, CAN5575BBorcherding Steven T · Anchorage, AKN5577BTheobald Daryl · Aberdeen, SDN5578BFrench Daniel T · Hobson, MTN5578MSky West Aviation Inc Trustee · Albuquerque, NMN5579BHutchison Robert T · Big Lake, AKN5580BLayman James D · Eagle, AKN5590BChambless Ronald Hugh · Abernathy, TXN5591BRegistered aircraftN5592BJopson James M · Newman Lake, WAN5593BQualick Robert N · White Rock, NMN5594BPara-Plane Aviation Inc · Thomasboro, ILN5595BLahn Dave R · Quincy, WAN5596BFlyventure LLC · Fort Wayne, INN5597BBucher Burton W · Waukegan, ILN559AKBurton John · Nacogdoches, TXN559DBRundle James R · Sparks, NVN559KMRegistered aircraftN559TJHangar 22 LLC · Watkinsville, GAN559TTMcdonald Aviation Mgt LLC · San Jose, CAN55AXWhite Drew C · Granbury, TXN55CGWick James · Canon City, CON55CPCharli Papa LLC · Clovis, NMN55DLHill Brock E · Palouse, WAN55HJRadlinger Joseph · Hudson, WIN55KAEvans Dick Trustee · Riverside, CAN55MStevens Donald K · Canton, GAN55MBSimon Caesar · Carmel, CAN55MRQc Executive Aviation LLC · Sheridan, WYN55NABloomhardt Theodore E · Hinesburg, VTN55NSBrown Nelson S · Auburn, WAN55PFBurris Adam Eugene · Graham, WAN55RHMccarthy Michael E · Martinez, CAN55RXJs Enterprises LLC · Clarinda, IAN55RYTwenty Nine Ninety Two LLC · Edina, MNN55SNHussey Arthur M III · Fairbanks, AKN55WBMetro Flyers Ltd · Wilmington, DEN55WMBankston Jeffery · Rice, TXN5600BParks Darryl D Trustee · Eagle River, AKN5601EMarshall Joseph · Uniontown, OHN5601JGoos Lynn A · Silver City, IAN5603JMiller Duane A · Redlands, CAN5604JJohnson David A · Sunrise Beach, TXN5609BWinkelman Ronald A · Chugiak, AKN560ABQuartermaster Growth LLC · Vashon, WAN5610JRael Pedro G · Los Lunas, NMN5611JJr'S Auto Care Center Inc · Gualala, CAN5612JNovember Aviation Corporation · Hobart, WAN5613JMorgan Edward A · Buchanan Dam, TX
Back to AD 84-10-01 R1