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.
N6701TAtlanta Aviation Academy Inc · Lawrenceville, GAN6701VHub City Aviation Academy LLC · Lubbock, TXN67022Mccormack James · Mount Jewett, PAN6702DMcwilliams Christopher S · Atlanta, GAN6702HGoetz Terry L · Defiance, IAN6702JWaldron Michelle M · Saranac, NYN6702NRoman Jose Ernesto · Guaynabo, PRN6702UKruse Benjamin · Phoenix, AZN6702XFlight Time Builders Inc · Memphis, TNN6703SSilverhawk Aviation Academy LLC · Caldwell, IDN6704DScaled Composites LLC · Mojave, CAN6704EWings Over Texas Holdings LLC · Denton, TXN6704JRussell John T · Southaven, MSN6704LSoflo Aviation LLC · Oakland Park, FLN6704NBethel William C · Murray, KYN6705JDuncan William E · Troy, IDN6705NGerback Andrew · East Canton, OHN67065Fort Wolters Helicopter Inc · Mineral Wells, TXN6706BZvacek Dennis E Trustee · Tulsa, OKN6706HDairy Air Inc · Wyoming, PAN6706NKorn Richard Mark · Lexington Park, MDN6706YSorbi Aviation Inc · El Cajon, CAN6707DMines Keith A · White Cloud, MIN6707HWjt Investments LLC · Gurley, ALN6707MLouis & Clark Aviation LLC · Fort Myers, FLN6707NRegistered aircraftN6707XGromack Stephen · Bloomfield, NMN6708BHartman Darrell W · Fish Lake Valley, NVN6708NBobby Stephen M · Dunkirk, MDN6708PWest Robert S · Gravois Mills, MON6708RStorey Timothy J · Camarillo, CAN6708SWininger Spencer C · Wichita, KSN6708UBlaedow Kyle R · Leesville, LAN6708XBaumbach James P · Lodi, CAN6709FMorning Star Transportation Inc · Dardanelle, ARN6709LBowlin Frank J · Santa Fe, NMN6709PRzewinski Leonard · Wading River, NYN670BBeck Mark A · Fort Wayne, INN670LHFf22 LLC · Scottsdale, AZN670MAVan Anda Aviation LLC · Apopka, FLN670MLQualitair LLC Trustee · MichelstadtN670RVSokoloski Gregory · Magnolia, TXN670SBDanles Enterprises LLC · Solvang, CAN670SCSpartan Education LLC · Tulsa, OKN670UBoard Of Regents Of The University Of Oklahoma · Norman, OKN670WBCt Cattle Co LLC · Wichita Falls, TXN6710BBarnard Matthew Bryan · Fort Worth, TXN6710NJohnson Kenneth W · Pine Bluff, ARN6710UMonroe Flying Club Inc · Glen Carbon, ILN6710ZHeatwole Oren · Dayton, VA
Back to AD 90-04-06 R1