AD 84-10-01 R1
Registered aircraft · 20,483
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N469MHWhat Could Go Wrong LLC · Murfreesboro, TNN469TCEast Pole Aviation LLC · E Setauket, NYN46AMDuffy Kevin · Manchester Center, VTN46BCHfc Inc · Halma, MNN46EFPringle Dan · Charlestown, INN46JFTisdell Michael S · Olivia, MNN46MRDavin Matthew · Ridgecrest, CAN46PCMace Robert C Jr · Gold Canyon, AZN46PGRegistered aircraftN46PKTensas Taildraggers LLC · Saint Joseph, LAN4700FAssociated Equip Representatives Inc · Yakima, WAN4701DMiller Larry L · Dade City, FLN4701URegistered aircraftN4702KUniversity Auto Sales Inc · Pell City, ALN4702QDriggs Daniel H · Anchorage, AKN4702WFour Flying Fools LLC · Geneva, FLN4703KSkeffington Robert C · Topsfield, MAN4704CWright Brian A · Nampa, IDN4704NScott Lester N · Pleasanton, CAFirst renewal noticeN4705KYi Ranches Lp · Reedley, CAN4705NBrentco Aerial Patrol Inc · Canton, OHN4705UIverson James P · Soldotna, AKN4706BCollegiate Peaks Aviation LLC · Salida, CON4706KWitman Michael R · Milliken, CON4706NReef Clipper LLC · Pittstown, NJN4706SGreat Lakes Aviation LLC · Burtchville, MIN4707BOlathe Spray Service Inc · Olathe, CON4707KKcsi Aerial Patrol Inc · Bakersfield, CAN4707NBrandon Gregory R · Talking Rock, GAN4707TVan Ausdall John C · Spring Branch, TXN4707UZero Seven Uniform LLC · Palmer, AKN4707VWhite Timothy C · Grapevine, TXN47084Tabor Peter C · Durango, CON4708NSkylane LLC · Billings, MTN4708VSpears Patricia C · Longmont, CON4709DMagalsky Jacob J · Wilsall, MTN4709KAlexander & Knizley Inc DBA · Mobile, ALN4709SMolinar Antonio L · El Paso, TXN470JCCox Patrick A · Torrance, CAN470PGreentree Aviation LLC · Sewell, NJN470RVFlyguys Aviation LLC · Bay City, MIN470XSale Reported · Priest River, IDSale reportedN4711DTimmons Colton R · Parker, CON4711FCharter Equine Inc · Amarillo, TXN4711KFhk Inc · Verona, PAN4712DWerkema Thomas L · Caledonia, MIN4714BGeissler Charles H · Stanton, MNN4714CGorman Aviation LLC · Bartlesville, OKN4714DWallace Brian T · Ogden, UTN4714NOwen John E · Aiken, SC
Back to AD 84-10-01 R1