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.
N8962NGallen Peter · Wilmington, DEN8962PDunning John · Stow, MAN8962YChoate Cass Joseph · Toone, TNN8963DDoyle Patrick H · Keller, TXN8963NBaker Daniel T · Jackson, OHN8963YNess Rent A Car Inc · Fargo, NDN8964DThomas Daniel C · Shady Shores, TXN8964JKemper Kevin K · Granite Bay, CAN8964PPerkins Michael W · Warren, MIN8964VOneill Jared · Gilroy, CAN8964W3720 To 1 Inc · Greenwood Village, CON8965DSale Reported · Beech Creek, PASale reportedN8965JN8965j LLC · Anchorage, AKN8965LWeber Daniel M · Oconomowoc, WIN8965PChancellor Richard · Palmer Lake, CON8965WWarlick Bradley Q · Negaunee, MIN8965YLucid Thought Consulting LLC · Terre Haute, INN8966DDodd Robert L · Humboldt, IAN8966JBrown Bradford K · Leoti, KSN8966NCherokee Six LLC · Minburn, IAN8966PLautensack Peter · Oswego, NYN8966VCreider Paul E · Tulsa, OKN8967JJust Plane Fun LLC · Sunrise, FLN8967TKellys Flying Service LLC · Warrensburg, MON8967YQualitair LLC Trustee · MichelstadtN8968DCleary Katherine E · Mulberry, FLN8968JStevens Raymond W · Norfolk, VAN8968QSonnichsen Landen D · Delta Junction, AKN8968VLittle Gordon D · Watertown, SDN8968WRc Skywagon LLC · Miami, FLN8969CStrahl Guenter H · Jackson, NJN8969NMatanane Roke C · Barrigada, GUN8969VCrowley Brett A · Wasilla, AKN8969WPostage Robert · Chapel Hill, NCN8969YTrident Aero Services LLC · Park City, UTN896ACAri Ben Aviator Inc · Fort Pierce, FLN896AKQuadcub Utah LLC · Salt Lake City, UTN896ASSilverstein Adam R · Pittstown, NJN896B49 Holdings LLC · Cheyenne, WYN896BCClute William A · Simpsonville, SCN896CFMiles Air Leasing LLC · Canonsburg, PAN896DFVenture North Aviation LLC · Cloquet, MNN896DLLane David A · Yuba City, CAN896JUniversity Of North Dakota · Grand Forks, NDN896SCHansen Ernest F · Sequim, WAN896SJTumbleweed Aviation LLC · Great Bend, KSN8970JAll Tech Machine & Tool Inc · Greenwood, ARN8970PPodraza Kevin M · Dekalb, ILN8970VWinding Creek Aviation LLC · Snellville, GAN8970WYoungblood Wade · Corsicana, TX
Back to AD 87-10-06 R1