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.
N84KLSpitfire-173 & Partners LLC · New Bern, NCN84KTTaylor Kevin G · Mountain Grove, MON84KYPaul Johnny D Jr · Camden, SCN84LAMav Air LLC · Rigby, IDN84LLLiebsch Mark · Reno, NVN84LPMinuteman Air Service Inc · Dewitt, ARN84MFPlanelease LLC · Mason City, IAN84MGSchroeder Mike J · Colby, KSN84MMEllison Phillip G · Castle Hayne, NCN84MSEdwards Bruce W · Palmer, AKN84NSale Reported · Eagle Point, ORSale reportedN84PSValiair Lc Trustee · Casper, WYN84PTTackabury Jenny Ann · Santa Paula, CAN84RLStockman Harold O · Elko, NVN84RMAugust Aero LLC · Kalispell, MTN84RPWellborn Michael Barrett · Broken Arrow, OKN84SAAshley Heating & Air · Wasilla, AKN84SFFifield Scott D · Overgaard, AZN84SKQuinlan John H · Claxton, GAN84SMRideinsky Aviation LLC · Daytona Beach, FLN84SSHoffman Thomas A- Trustee · Emmett, KSN84TDBailey Dennis · Kernersville, NCN84TKRegistered aircraftN84TXBrooks Nathan · Manhattan, KSN84VCExperimental Flight Test Solutions LLC · Seattle, WAN84WAFlying High LLC · Selah, WAN84WMErickson Lee A Trustee · Fargo, NDN84WPJayanthi Venkata R · Columbus, OHN84WTAndreotti Mark C · Colusa, CAN84ZRomeo Aviation Ltd · East Sparta, OHN85007Sidell Joel R · Brighton, CON8500DScootair LLC · Alburgh, VTN8500UGlobal First Capital Aviation Group LLC · Amarillo, TXN8501DStrausser Brian J · Lower Burrell, PAN8501LSnider Scott E DBA · Turner, MTN8502DConrad Dylan · Randolph, WIN8502NDickman Edward A · Melba, IDN8502VAngel Aviation Inc · Peoria, AZN8502WWinker Kurt F · Los Lunas, NMN8503EB&B Aviation Holdings LLC · Pembroke Pines, FLN8503NKirkland Joseph Talmadge III · Memphis, TNN8503YRoberti John O · Barre, VTN8504LTexas Soaring Association · Midlothian, TXN8505Lunetta Peter Joseph Jr · Niskayuna, NYN8505DRegistration Pending · Wilmington, DERegistration pendingN8505NMahffey Gary L · Parachute, CON8505WMcnamara Kevin Jr · East Aurora, NYN8505YCli Aerospace LLC · Appleton, WIN8506NTiller Aviation LLC · Omaha, NEN8506WWestenburg Garrett V · Porter, TX
Back to AD 87-10-06 R1