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.
N7570WWatkins Andrew B · Redding, CAN75710Cox Leon F · Ruffin, NCN75711Falcon Air LLC · Anchorage, AKN75712Hill David Ryan · Palm City, FLN75714Lincoln Skyways Inc · Lincoln, CAN7571GCook Thomas B · Boston, MAN7571HChristman Christopher D · Chugiak, AKN7571PScribner George W · Suffolk, VAN7571VRothstein Tim P · Litchfield, MNN7571YPipers Are Still Better LLC · Carson City, NVN75721Propell Air LLC · Deridder, LAN75722Pt Real Estate Inc · Port Hadlock, WAN75724Lenamond L Don Jr · Anchorage, AKN75726Don Davis Aviation Inc · Henderson, KYN75727Silverhawk Aviation Academy Oregon LLC · Ontario, ORN7572ENibbe Douglas L · Saint James, MNN7572FKinder Mark E · Scottsdale, AZN7572HStark Jeffrey J · Fairbanks, AKN7572VOffshore Services Ltd · Block Island, RIN7572WRegistered aircraftN7572YBlack And Faraday Inc · Pencil Bluff, ARN75731Ziegler Carl F · Forest Lake, MNN75733Red Door Aviation LLC · Dover, DEN75739Entroair LLC · Hilliard, OHN7573FDirks Daniel P · Seguin, TXN7573GBecker Todd J · Arlington, NEN7573HSugden Richard M · Hallock, MNN7573KPeile Kelly · Lakeview, ORN7573PPurcell John H III · Mechanicsville, MDN7573RMonadnock Choppers LLC · North Swanzey, NHN7573VOlson Jerome W · Kerrville, TXN7573YLawrence Earl A · Alexandria, VAN7574Charles Farms Inc · Lancaster, PAN75740Kingdom Air Corps · Sutton, AKN75743Aerosmith Aviation LLC · Panama City Beach, FLN75744Blue River Aviation LLC · Palmer, AKN75746C-Squared Aviation LLC · Delaware, OHN75748Porter Steven C · White Rock, NMN75749Mckinstry Adam V · Hubbardston, MIN7574BHuey Andrew G · Fulton, MON7574DDixon Thomas R · Lance Creek, WYN7574EWalpierre LLC · Indiana, PAN7574FDriskill Larry W · Lubbock, TXN7574HMiller Thomas L · Ennis, MTN7574JBayviators Flying Club · Mechanicsville, MDN7574KPhair David E · Dixfield, MEN7574PMatark Corp · Pullman, WAN7574RWilliams Brian M · Lisbon, OHN7574VWild Angels Aviation LLC · Lascassas, TNN7574YWdc Aviation LLC · Williamsburg, VA
Back to AD 90-04-06 R1