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.
N5059KLucia Keith G · Pleasant Hill, CAN5059LAeromarine Airways Corp · Miami, FLN5059NSchultze Joseph Dale · Mound, MNN5059PVertical Edge Enterprises LLC · Chandler, AZN5059TGimenez Roberto Jorge · Merritt Island, FLN5059WSmith Michael L · Satellite Beach, FLN5059ZWarren Kenneth N · Anamosa, IAN505AFAmeriflyers Of Texas Inc · Addison, TXN505ATGraupman Gerald · Chicago, ILN505CEMoore Travis S · Montrose, CON505CK7l Ranch Operations LLC · Pyote, TXN505EGShamrock Aviation Resources LLC · Paulden, AZN505EPSuper 21 LLC · Litchfield Park, AZN505FLComer Christopher C · Randleman, NCN505GAlford Robert S · Columbus, GARegistration revokedN505GSVolar Corp · El Cajon, CAN505JFRegistered aircraftN505JPRbh LLC · Lagrange, GAN505LShores Robert C · Rocklin, CAN505LPWifa (Washington International Flight Academy) LLC · Gaithersburg, MDN505MRVance Thomas E · Riverhead, NYN505RVOtero David · Albuquerque, NMN505SCSpartan Education LLC · Tulsa, OKN505SHHitchens Steven L · Newark, OHN505TFHawkins Larry L · Farmington, NMN505WTOlive Tyler A · Grass Valley, CAN505XCConnell Billie L II · Valdez, AKN505YRMarshall Douglas W · Blackfoot, IDN505ZRoddy Bonnie J · Holly Lake Ranch, TXN5060CEriksmoen Neal A · Fargo, NDN5060GSpragues Aerial Spraying Inc · Courtenay, NDN5060JEeds Lucky L · Claude, TXN5060LVassilou Dimitri · Berwyn, PAN5060MBowden James Jr · Fairbanks, AKN5060NNarveson Bryce J · Nerstrand, MNN5060TAirzona Aircraft Services Inc · Kingman, AZN5060UPeoples Douglas A · Horseshoe Bay, TXN5060XFour Guys Flying LLC · Tunica, MSN50615Stinger Tailwheel LLC · Miami, FLN50616Burge Kimberly · Wasilla, AKN50619Registered aircraftAssigned, pending cancellationN5061DKnight Frederick T · Arkadelphia, ARN5061GMoore David B · Wasilla, AKN5061KSchweiss Charles · Fairfax, MNN5061NGroth Matthew C · Arlington, WAN5061TSullivan Patrick James · Avery, CAN5062CSchiegner Kyle Glen · La Mesa, CAN5062DRoberge Guy C · Westborough, MAN5062GMore Right Rudder LLC · Menlo Park, CAN5062JDomack Christopher S · Toccoa, GA
Back to AD 90-04-06 R1