AD 84-10-01 R1
Registered aircraft · 20,483
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.
N3183CWide Open Aviation LLC · Kennewick, WAN3183DT2k Aircraft · Austin, TXN3183QMj Syndicate LLC · Vancouver, WAN3183RRusso Anthony G · Melbourne Beach, FLN3183SJohnson Richard · Winnebago, MNN3183YAlc Aviation LLC · Milwaukee, WIN3184DRitchie Rex W · Lopez Island, WAN3184QBeaugh Anthony H · Platteville, CON3184RGardner Daniel J · Alvord, TXN3184SThrash Farms Inc · Pelahatchie, MSN3184YFunkhouser David E · Weatherford, OKN3185DMorgan Douglas C · Anchorage, AKN3185F85 Foxtrot LLC · Redmond, ORN3185QPara Tactics LLC · Shelton, WAN3185YGochenour Air Inc · Fort Wayne, INN3186DSutton Aircraft Salvage LLC · Palmer, AKN3186QKimbril Steve · Hartselle, ALN3186RHuey Gale R · Celeste, TXN3186YJram Air Parts LLC · Henderson, NVN3187CHemm Colby L · Newcastle, CAN3187FVolatile Aero Ventures LLC · Boulder City, NVN3187UMillikan Kimball S · Honolulu, HIN3187YMiller Richard G · Anson, TXN3188QLutz Paul A Trustee · Seville, OHN3188SCrossman Charles · Rusk, TXN3188UAsb Avionics LLC · Mojave, CAN3188YIngram Patrick Joseph · Pinedale, WYN3189CSmith David J · Duluth, MNN3189SMarvin Franz Interests Inc · Victoria, TXN3189ULaney Donald R · Inkster, MIN318CCVan Schoonhoven Nicholas R · Kent, WAN318DMDelta Kilo Mike LLC · Rayville, LAN318LLLee Aviation Services LLC · Wilson, NCN318SJObr Leasing · Manassas, VAFirst renewal noticeN318WCDelta Dusters LLC · Lake Providence, LAN3190DDooyema Eric · Spokane, WAN3190FTimbol Julius J · Fair Oaks, CAN3190QHilton John C · Glastonbury, CTN3190RPace Richard · Leighton, ALN3190UTo Brand · Stanton, TXN3190YSpencer Thomas D · Brentwood, TNN3191CVaneau Phillip M · Wasilla, AKN3191RLv Aviation LLC · Pompano Beach, FLN3191SSkydive Harbor Springs Inc · Charlevoix, MIN3191THappy Landings Aviation LLC · Maple, NCN3191UWings Of Hope · Chesterfield, MON3192CHansen Leland K · Phoenix, AZN3192QSeel Jason L · Oak Creek, WIN3192RFuchs Robert D · Easton, PAN3192SFrandsen Perry D · Sandy, UT
Back to AD 84-10-01 R1