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.
N7443JPiper Aero Adventure LLC · Port Orange, FLN7443RClarkson Brett D · Stuarts Draft, VAN74442International Air Services Inc Trustee · Carson City, NVN74447South Texas Aviation Group Inc · Helotes, TXN7444DRups Adventure North LLC · Arbor Vitae, WIN7444RMarchionda Bruce · Sherman, TXN7444WMedia Stew LLC · Carson City, NVN74451Continuous Improvement Solutions Llp · Bella Vista, ARN74452Delmarva Skies LLC · Milton, DEN74453Wientjes Randy R · Metropolis, ILN74458Flying Tiger P40 LLC · Healdsburg, CAN7445JNosal Ivan · Itasca, ILN7445PN7445p Flying Club LLC · Union City, CAN7445WArola Anthony L · Tacoma, WAN7445YCherish Aviation LLC · Woodbridge, VAN74465Clarabut Alexander · Santa Clara, CAN74466Weakley Byron D · Chapmansboro, TNN7446DNeufeld Bernie T · Dalhart, TXN7446FAir Sprayers Inc · Two Buttes, CON7446JLkn Aviation LLC · Cornelius, NCFirst renewal noticeN7446REckert Travis R · Texarkana, TXN7446YN7446y Aero LLC · Joplin, MON74470Barbeau Timothy A · Saint Peters, MON74472Willis John B · Katy, TXN74478Sato Steven S · Green Bay, WIN7447JWiley Calvin · Summer Shade, KYN7447KNiemyjski Justin S · Franksville, WIN7447NJc Flight Inc · Wilmington, DEN7447RCompo John · Essex Junction, VTN7447VBaca Robert A Trustee · Auburn, CAN74481Holley Jack · Morehead, KYN74487Pierce David J · Alpine, UTN7448RCraddock Ellis G · Colorado Springs, CON7448WBoyce Gillis · Savannah, TNN7449GAvmajic LLC · Waterford, MIN7449KBuehler Andrew · Eatonville, WAN7449WMutch Robert E · Barrington, NHN7449YMiddle Georgia Aviation Inc · Cochran, GAN744AAtp Aircraft 6 LLC · Wilmington, DEN744BBCooper Roy · Lamesa, TXN744CWSmith Shepard E · Los Angeles, CAN744DMMaloney Daniel D · East Amherst, NYN744DSShuey Jack L Jr · Owego, NYN744ESUsaircraft Inc · Newark, DEN744JAWiebe Albert · Seminole, TXN744JNAvia Flight Academy LLC · Stratford, CTN744MDeforest Shawn L · Lexington, NCN744MTChrisman Kenneth A · Spring, TXN744NDAir Shares LLC · Casper, WYN744PASkywest Leasing Inc · Saint George, UT
Back to AD 90-04-06 R1