AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N81LLJma Aviation LLC · Lakin, KSN81LSPedulla Rich · Wyalusing, PAN81MBBradford Michael H · Zephyr Cove, NVN81MDTt Twins LLC · Fayetteville, GAN81MFSchneider Paul Scott · Manahawkin, NJN81MHSvedrovic 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, MDN81RPLull William G · Ramona, CAN81SHSharff Steven T · Georgetown, DEN81SMSchwartz Grantham L · Garden City, TXN81TDAfmr Inc · Dover, DEN81TRCarter Ted J · Bigfork, MTN81TTPizzo David A · Warren, ORN81VKMiller Robert G · New Carlisle, OHN81VMDouglas Stephen R · Wills Point, TXN81WBGibbs 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, WYN8200GRj Vincent Enterprises LLC · Rancho Santa Fe, CAN8200KRoss 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, CAN8201CSheard Scott R · Chugiak, AKN8201GMetzgen Richard A · Groveland, CAN8201NLang Peter J · Coopersburg, PAN8201QEhmka Mitchell · Lombard, ILN8201W8201w General Partnership · Wilbraham, MAN8201XPotter Jan Charles · Tangerine, FLN8201YTorqmation Inc · Houston, TX
Back to AD 81-18-04 R2