AD 87-10-06 R1
Registered aircraft · 72,010
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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.
N9604SFmco Promotions Inc · North Little Rock, ARN96052Copp James E · Adin, CAN9605CA O G Aircraft Services LLC · Aberdeen, NJN9605DDirty Side Down LLC · Downers Grove, ILN9605EMckinney James R · Saint Charles, MON9605MAsv Aviation LLC · Salem, ORN9605QBragan Ryan J · Dunedin, FLN9605RStieglitz Jeffrey B · Firth, IDN9605VBrookhart Brent Robert · Anaconda, MTN9605ZBorror Kevin Bruce · Grants Pass, ORN96060Silver Creek Ranch Inc · Austin, NVN9606DNiemi Danny L · Osage, MNN9606SMix Timothy R · Hubbard, ORN9606WMandolesi Daniel Martin · Hulmeville, PAN9607CLmc Aviation LLC · Goleta, CAN9607DRomo Mark A · Dillingham, AKN9607HTwin Oaks Airpark Inc · Hillsboro, ORFirst renewal noticeN9607RJohnston Bradley G · Ossining, NYN9607TPeterson Bradley E · Williston, NDN9607WK-9 Handler LLC · Henderson, NVN96088Griffith Kruz S · Bakersfield, CAN9608FDraper Floyd L · El Paso, TXN9608HCag Aircraft Holdings LLC · Crystal River, FLN9608JGomm Bruce J · Colfax, NDN9608KPiper Arrow N9608k LLC · Ann Arbor, MIN9608MWaryas Robert A · Long Island, VAFirst renewal noticeN9608QLahmers Melvin E · Newcomerstown, OHN9608RB2 West Corporation · Winona, MNN9608UNorth Shore Aviation LLC · Honolulu, HIN9608WBright Skies Sales & Leasing LLC · Hendersonville, TNN9609HWilliams Marc A · Fallon, NVN9609JAdams Donald J · Lock Haven, PAN9609PMerlin Aviation Inc · Moriarty, NMN9609QWestrup Gregory W · Greensburg, INN9609VFly Fly Fly LLC · Dover, DEN9609WCullen Michael R · Fort Mohave, AZN960ACNaples Air Center Inc · Naples, FLN960DGN960dg LLC · Idaho Falls, IDN960FSSouthern Aero LLC · Homestead, FLN960GSStevens Chad M · Huntsville, ALN960KMMorris Ag Air And Sons Inc · Orovada, NVN960RMCag International Inc DBA · Longmont, CON960RSSouthard James E Jr · Charleston, SCN960RVHouse Gregory E · Sealy, TXN960TAInnoutaero LLC · Stockton, CAN960TEBeauregard Timothy · Haslet, TXN960VSSauder Philip J · Peninsula, OHN960WCStardust Aviation LLC · Farmingdale, NYN96100Trajectory Aviation LLC · Hollywood, FLN96105Demon Air LLC · Palm City, FL
Back to AD 87-10-06 R1