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.
N81MHSvedrovic Alex P · Waterbury, CTN81MLLovelace Malcolm E · South Vienna, OHN81MMMangum Aviation Inc · Pasadena, TXN81MXApodaca Alvarez Alan · Los Angeles, CAN81PBCollins Jay D · Midwest City, OKN81PCNimbus Aviation LLC · Ponte Vedra Beach, FLN81PDMetz Robert J · Peever, SDN81PKTier-1 Helicopters LLC · Hampton, GAN81PMSpinnaker Aviation LLC · Conroe, TXN81PSPetro Jerry R · Williamsburg, VAN81PWHart Services LLC · Mt Pleasant, SCN81RBBogar Blake A · Raymond, WAN81RGRemsberg Edwin H · Fallston, MDN81RHSpecialty Aviation II LLC · Jupiter, FLN81SHSharff Steven T · Georgetown, DEN81SMSchwartz Grantham L · Garden City, TXN81STAxion Inc · Huntsville, ALN81TDAfmr Inc · Dover, DEN81TRCarter Ted J · Bigfork, MTN81TTPizzo David A · Warren, ORN81WBGibbs Anthonee M · Ridgefield, WAN81WDRandolph Dean R · National City, CAFirst renewal noticeN81XMNoble Gary D · Sioux Falls, SDN81XPKlucas Steven G · Lakeville, MNN81ZWWiens Zachary S · Portland, ORN82005S&H Leasing LLC · Sarasota, FLN82006Marquiss Gary C · Gillette, WYN82008Craige Danny D Trustee · Durant, OKN8200KRoss Lanson C · Labelle, FLN8200PSix Five Papa Inc · Temple, NHN8200VHills Holding · Newark, DEN8200YCj Industries LLC · Chesnee, SCN8200ZFlack Norma Jeanne · Fort Lauderdale, FLN82016Armstrong John Russell Jr Trustee · Commerce, TXN82017Russell Alex B Jr · Soldotna, AKN8201ABeggs Daniel · Royston, GAN8201BTammi Mark K · Grass Valley, CAN8201NLang Peter J · Coopersburg, PAN8201QEhmka Mitchell · Lombard, ILN8201W8201w General Partnership · Wilbraham, MAN8201XPotter Jan Charles · Tangerine, FLN8201YTorqmation Inc · Houston, TXN82022Hard Luck Aviation LLC · Tok, AKN8202ERegistered aircraftN8202WN8202w LLC · American Fork, UTN82035Troia Andrew · Homer, AKN8203DVans Holding LLC · Canton, OHN8203KHandy Air Inc · Douglas, GAN8203NPope Jimmy M Jr · Eastover, NCN8203PDell John J · Saint Clair Shores, MI
Back to AD 87-10-06 R1