AD 85-03-01
Registered aircraft · 1,385
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:85-03-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:85-03-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:85-03-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:85-03-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.
N1754USutton Aircraft Salvage LLC · Palmer, AKN1758UBas Part Sales LLC · Greeley, CON17CJ16d Aviation LLC · Vashon, WAN17HSRed Oak Centurion LLC · Red Oak, IAN17JYYorkavitz James B · Valley City, OHN17NFBravo Hotel LLC · Lewes, DEN17TCKenyon Walter C · Eureka Springs, ARN1800FReid Brian M · Boise, IDN1801ZGould Robert R Jr · Sterling, VAN1802FSantiago Ferdinand · Calhoun, GAN1802ZSparks Timothy J · Jackson, MIN1804FWaage Todd · Greenbush, MNN1808ZFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVNon-citizen corporation, flight hours not reportedN1809ZCleared For Departure LLC · Kennewick, WAN1810ZRanzway Corp · Seattle, WAN1814FAlpine Cable And Construction Inc · Grand Junction, CON1816FMalcom Scott O · Toledo, WAN181DHWinkler Jeffery L · Brush, CON1820ZStaats Douglas E · Anchorage, AKN1821FAlexander Travis · Hudson Oaks, TXN1821SBailey Ralph E · Sikeston, MON1822ZAhrens Kevin Michael · Cashmere, WAN1825ZGreentek Inc · Oroville, CAN1828FDrew Kevin · Fredonia, PAN1828ZHorrocks Charles M · Blackfoot, IDN1833FHale Jay · Corpus Christi, TXN1833ZEastwood Gregory S · Red Oak, TXN1835ZRegistered aircraftN1838ZAgee Mark L · Greenacres, WAN1839FHentz Randy Reuben · Tower City, PAN1842ZVermont Skydiving Adventures Inc · Bristol, VTN1843FJordan Jay · Centre, ALN1843ZVacek George T Jr · Anchorage, AKN1844ZN1844z LLC · Hillsboro, ORN1845FJones Sandy Ray · Williamsburg, NMN1848ZBritt Robert J · Augres, MIN1849FCrouse William F · Priest River, IDN1852FSymbot Management Inc · Dover, DENon-citizen corporation, flight hours not reportedN1854FHarlan Bradley J · New Brighton, MNN1854ZBargabos William M · Wasilla, AKN1858ZPairofminutes LLC · Marshville, NCN1859FBaker Robert J · Ogema, MNN1863FAndersen Dana K · Scappoose, ORN1864FSwensen Nathan E · Winnemucca, NVN1865ZBpf Equipment LLC · Burnet, TXN1867FIcarus Aviators LLC · Canon City, CON1868ZZulu Forty One LLC · Anchorage, AKN1869FRegistration Pending · Dublin, OHRegistration pendingN1869ZPinnell Bradley T · Lake Havasu City, AZN186RDWayson Air LLC · Mount Auburn, IA
Back to AD 85-03-01