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.
N6882YFlamingo Air Inc · Cincinnati, OHN6883BSlagle Allen E · Newcastle, WYN6883JRobbins John L · Crossville, TNN6883NAj Mooney LLC · Port Saint Lucie, FLN6883VHubbell Carl · Crowley, TXN6883ZFoster Gary L · Palmer, AKN6884HWings Over Texas Holdings LLC · Denton, TXN6884JHbk Flyers LLC · Alton, ILN6884NLutes Kent A · Tazewell, TNN6884USheaffer Bruce R Jr · Lititz, PAN6884VVan Dyck Ryan G · Talent, ORN6885HRasmussen Stewart · Santa Barbara, CAN6885NPoskevich Douglas · Deland, FLN6885UGranier Bernie C Trustee · Bandera, TXN6885WMiller Andy D · Marana, AZN6886BOhmans Inc · Gillette, WYN6886HParr Larry · Clarksville, TNN6886JFlanders David J · Madison, WIN6886NSibille Keith Curtis · Griffin, GAN6886PBas Part Sales LLC · Greeley, CON6886UN6886u Inc · Tucson, AZN6886WGregory Joshua L · Oxford, MSN6887JBas Part Sales LLC · Greeley, CON6887NColton Frank Lasusa · Harrisburg, PAN6887UAce Aircraft Leasing Inc · Nazareth, PAN6888BVenell Farms Inc · Corvallis, ORN6888DCenter Charles C · Wasilla, AKN6888FAtlanta Peach Air LLC · Oxford, GAN6888HN6888h LLC · Wayne, NJN6888JMovable Air LLC · Oldsmar, FLN6888NGrass James Conrad · Phoenix, AZN6888PKempf Douglas A · La Center, WAN6888WAnderson Ty M · Grenada, MSN6888YFlying W Leasing Inc · Bartlett, ILN688AGrasky Endurance Coaching LLC · Tucson, AZN688BGJones William E · Birmingham, ALN688CABetter Southlake Properties LLC · Pagosa Springs, CON688HZumbrun Dennis L · Montz, LAN688KKing William K · Rockwall, TXN688LHChristiansen Aviation LLC · Wilmington, DEN688MBHill Frank G · Navarre, FLN688NDUnd Aerospace Foundation · Grand Forks, NDN688PAJoe P Fassio · Union, WAN688RMBurton Jason S · Howell, MIN688TAircapital Nevada Inc · Carson City, NVN6890Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN6890LTop Tier Truck And Trailer LLC · Dimmitt, TXN6890PMarble Jere D · Dayton, NVN6890RBudgeon Mark K · Mandeville, LAN6890WRegistered aircraft
Back to AD 87-10-06 R1