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.
N981CCengiz John · Clifton, NJN981CMClaypool James W · Hunts Point, WAN981CPCivil Air Patrol Inc · Maxwell Afb, ALN981JPBull Six LLC · Edmond, OKN981MARed Rose Flight Tours LLC · Lancaster, PAN981MMMccalmont Marc W Trustee · Springfield, NHN981RVOwen Scott E · Missoula, MTN981SHSmith Helicopters Inc · Cotulla, TXN981SLRotor Technologies Inc · Nashua, NHN981SPLlp Leasing Group LLC · Lewes, DEN981SUHoloubek Mark R · David City, NEN981WSNayrmarc LLC · Linden, MIN981WUEastern Kentucky University · Richmond, KYN98203Rfb Cherokee LLC · Perkinston, MSN98205Uhlemeyer Douglas · O Fallon, MON98208Anderson James D · Tecumseh, MIN9820HSeghieri Richard T · Santa Rosa, CAN9820WMcgahan Merrill M · Kenai, AKN98210Hancock Ricky L · Anchorage, AKN98212Alpha Aviation Group LLC · Clawson, MIN98218Engleman Roy J · Mcalester, OKN98219White Jeffrey M · Carlsbad, CAN9821GGrubelich Mark C · Edgewood, NMN9821UCoquimbo Capital Holdings LLC · Sandy, UTN98222Diol Ranjit S · Dowagiac, MIN98223Lustig Keith C · Clyde, MIN98226Whited Ronald Glenn · Tampa, FLN9822UMoyer Curtis · Bedford, INN9822VJohnson Mark W · Valrico, FLN9822YMontana Aviation Tryst LLC · Kalispell, MTN98237Pierce Teddy D · Savannah, MON98239Sushko Michael S · Plymouth, MNN9823LSilverhawk Aviation Academy LLC · Caldwell, IDN9823MKoelsch Benjamin · Nome, AKN9823UMorrow Robert C · Edgewater, FLN98240Petersen Amos I · Iowa City, IAN98241Lh Investments Inc · Albany, ORN98242Husbands Klayton P · Bosque, NMN98244Kingsbury Janet L · Miramar, FLN98249Tramper Air LLC · Rockford, MIN9824JBarksdale James Alan · Florence, ALN9824LSt Pete Aviation Services LLC · Saint Petersburg, FLN9824PKnutson Wayne R · Thompson, NDN9824UPurpose Flight International LLC · Wilmington, DEN9824VSafety In Motion Flight Center · Puyallup, WAN98251Wings Over Texas Holdings LLC · Denton, TXN98257Fly High Aviation LLC · Miami, FLN9825GKanawha Aviators LLC · Bancroft, WVN9825WBunch Matthew B · Georgetown, KYN98263Myers Bobby L · Brookhaven, MS
Back to AD 87-10-06 R1