AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-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:90-04-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:90-04-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:90-04-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.
N81EMMalone Mark R · League City, TXN81ESBranciforte Louis N · Watsonville, CAN81FBStack John A · Trenton, SCN81GWWolfe Ian Sean · Spring Branch, TXN81HSHarris David C · Ventura, CAN81HYAviat Aircraft Inc · Afton, WYN81JACsukay Orkideh · Reseda, CAN81JDBarbour Grays Inc DBA · Buckhannon, WVFirst renewal noticeN81JFMains Donald L · Hiram, MEN81JGGreaves Jr John P · Redding, CAN81JRPlane Fun Inc Tr Trustee · Snellville, GAN81JVVoss James S · Boulder, CON81KWZweigle Zachary J · Redding, CAN81LERieger Mark W · Woodland, CAN81LKKinder Larry R · Fort Myers, FLN81LLJma Aviation LLC · Lakin, KSN81LSPedulla Rich · Wyalusing, PAN81MBBradford Michael H · Zephyr Cove, NVN81MDTt Twins LLC · Fayetteville, GAN81MHSvedrovic 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, SDN81PMSpinnaker Aviation LLC · Conroe, TXN81PSPetro Jerry R · Williamsburg, VAN81RBBogar Blake A · Raymond, WAN81RGRemsberg Edwin H · Fallston, MDN81RPLull William G · Ramona, CAN81SHSharff Steven T · Georgetown, DEN81SMSchwartz Grantham L · Garden City, TXN81TDAfmr Inc · Dover, DEN81TTPizzo David A · Warren, ORN81VERegistered aircraftAssigned, pending cancellationN81VKMiller Robert G · New Carlisle, OHN81WBGibbs 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, FLN8200VHills Holding · Newark, DEN8200ZFlack Norma Jeanne · Fort Lauderdale, FLN82016Armstrong John Russell Jr Trustee · Commerce, TXN82017Russell Alex B Jr · Soldotna, AK
Back to AD 90-04-06 R1