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.
N4308QN4038q LLC · Merritt Island, FLN43091Reid Royce · Ferndale, WAN43094Auburn Aeroplane Inc · Ft Wayne, INN43095Rogers Danny · Florence, KYN43098Forest City Aviation Inc · Forest City, IAN43099Bennick Frances E · Andreas, PAN4309AParylak Sean P · Colchester, CTN4309HAutumn Oaks Air LLC · Chicago, ILN4309JHorn Rodney L · Friendswood, TXN4309PSibille Philippe B · Waller, TXN4309QCamp Harold S Jr · Bossier City, LAN4309XFizer Charles Sutton IV · Orlando, FLN4309ZMccue Ryan D · Anchorage, AKN430AVN1534x LLC · Manassas, VAN430BSCoyle Christopher Neal · Portland, ORN430BZHirschman David M · Ijamsville, MDN430CPCivil Air Patrol · Maxwell Afb, ALN430DHHolbrook Dennis V · New Plymouth, IDN430DSDelaware State University · Dover, DEN430FSCustom Air International LLC · Homestead, FLN430HHuntsinger Robert J · Bothell, WAN430JPAuchincloss John W · Weston, CTN430KPChase Donaven R · Lake Elmo, MNN430MDMattes Michael A · Churubusco, INN430NDUniversity Of North Dakota · Grand Forks, NDN430RKHicks Robert C Jr · Alamogordo, NMN430RMRocky Mountain College · Billings, MTN430TCNorth Star Aviation Inc · Mankato, MNN430TLAgold Terry G · Tehachapi, CAFirst renewal noticeN430YClark Samuel · Shoemakersville, PAN430ZAlpha Tango Aircraft LLC · Wilmington, DEN4310FKomair Inc · Smallwood, NYN4310HJohnson Ryan A · Dodgeville, WIN4310PChimera Air Inc · Maumee, OHN4310QRonceverte Fliers Incorporated · Asbury, WVN4311ALopez Jennifer L · Fort Rucker, ALN4311JWalk Eugene P Jr · Barnegat, NJN4311PRitchie Glenn R · King George, VAN4311QLink John · West Milford, NJN4311TChandler Air Service Inc · Chandler, AZN4311VWayne Braden M · Greenbrier, ARN43120Inge Jame B Jr · Crewe, VAN43124Beale Air Force Base Aero Club · Beale Afb, CAN43125Alpha 1 Aviation LLC · Helena, ALN43126Bdc 43126 LLC · Dumfries, VAN43128United States Air Force Owner · Hanscom Afb, MAN4312FUniversal Aviators Academy Inc · El Monte, CAN4312RHorizon Group Inc Trustee · Boca Raton, FLN4312TByron James D · Houston, TXN4312YWhittom Ron W Jr · Wasilla, AK
Back to AD 90-04-06 R1