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.
N881DBJetprop Holdings LLC · Santa Fe, NMN881DCGoldfarb Martin · Scottsdale, AZN881DSSeltman Jack A · Wichita, KSN881DTCleary Brothers LLC · Tompkinsville, KYN881FTFlorida Institute Of Technology · Melbourne, FLN881GLActualized Business Solutions Inc DBA · California, MDN881JBHammer Roger W · Seattle, WAN881JFGriffin Aviation LLC · Minneapolis, MNN881JRFinnegan Brian E · Waterloo, IAN881KBAero Quest LLC · Olive Branch, MSN881KEPorter Equipment Holdings LLC · Magnolia, TXN881MAHunt William E · Helena, MTN881PUTrustees Of Purdue University · West Lafayette, INN881RDOrchard Richard W · Sagle, IDN881RVKeeslar David L · Sturgis, MIN881RWWilliams Summit LLC · Salmon, IDN881SPIllinois State Police · Springfield, ILN881TAMcgough Julie E · Red Oak, TXN881WABlahut Robert John · Prosser, WAN88200Auer William E · Saint Petersburg, FLN88202Moore David J · Beechgrove, TNN8820DMayo Jesse J · Fairbanks, AKN8820EDishman John David · Brooklyn, NYN8820JSurles Willian T · Chuckey, TNN8820VDiversified Dialysis Services Inc · Lithonia, GAN88214Mcclanahan John B · Fayetteville, GAN88215George Gary D · Humble, TXN8821ERegistration Pending · Dothan, ALRegistration pendingN8821FRuhlman Dan C · Youngsville, PAN8821JJanssen Brittney Juen · Pleasantville, IAN8821LSouthern California Soaring Academy Inc · Valencia, CAN88223Mather Don A · Sandusky, OHN88227Acadian Dusters LLC · Church Point, LAN8822DWhite Glen A · Timber, ORN8822NFirestine Joseph W · Atwater, CAN8822PCornwell Charles E · Tucson, AZN88230Smithson Charles W · Wasilla, AKN88233Dupont Larry W · North Hero, VTN88237Bas Part Sales LLC · Greeley, CON8823CMcgee David · West Monroe, LAN8823FHudson Valley Helicopters Inc · Wilmington, DEFirst renewal noticeN8823JBas Part Sales LLC · Greeley, CON8823NAvia Flight Academy · Stratford, CTN8823PSite Solutions LLC · Bottineau, NDN8823WSpaulding Anthony Russell · Sonoma, CAN8823YFerrara John M · Newtown, PAN88241Walters Eugene H · Maupin, ORN88245Steinle Michael · Lake Village, INN8824CRodriguez Carlos S · Poughkeepsie, NYN8824ECornelius John A · Fort Worth, TX
Back to AD 87-10-06 R1