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.
N9219VChen Brian K · Bakersfield, CAN921AARegistration Pending · Deland, FLRegistration pendingN921BLLewis Bertrand V · Glendale, AZN921DCCarlson Donald A III · Lexington, TNN921JKShackleford Wayne D · Riverside, CAN921KCRocket City Helicopters LLC · Brownsboro, ALN921LCCrum Robert W · Lake Havasu City, AZN921NDUniversity Of North Dakota · Grand Forks, NDN921PABird Acquisition LLC · Phoenix, AZN921PCProppe Karl H · Needham, MAN921RCCall Raymond T · Batesville, INN921RSSpry Mark W · Elkmont, ALN921SJDavis Brandon Grey · Huntsville, ALN921TAAtp Aircraft 4 LLC · Wilmington, DEN921TCBell Charles S · Fort Payne, ALN921UTumbleweed Leasing Co Inc · Salt Lake City, UTN921WC7 Corp · Orlando, FLN921WJJones Wesley C · Yuba City, CAN921XPLengler Aviation LLC · Fort Myers, FLN922Tjk Enterprises LLC · Helena, MTN9220DEllis Harvey Airport Inc · Guthrie, OKN9220MBeaty David · Santa Fe, NMN9220SWard Jessica · Southport, NCN9221DOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLN9221JJgms Rose LLC · Stamford, CTN9222DMatthews David C · Fairbanks, AKN9222LTyler Timothy C · Wyoming, OHN9222SSvendsen James · Center Moriches, NYN9222VSoco Scuba LLC · Austin, TXN92236Garfoot William K · Verona, WIN9223FMckeeman Kevin · Abilene, KSN9223HHallock Robert C III · Sag Harbor, NYN9223JRudo Mark R · Milton, DEN9223LHogan Fredrick C · Oviedo, FLN9223VQuick Janice L · Wrightwood, CAN92247World Class Aviation Ltd · Bellefontaine, OHN9224JJackson Jonathan · Siloam Springs, ARN9224LAnalytical Technologies Inc · Miami, FLN9224VBevington Carl R · Middle Point, OHN92255Kloker Daniel E · Owasso, OKN92258Mendez Leonel Jr · Corpus Christi, TXN9225CMeriden Aviation Center LLC · Meriden, CTN9225LTerry Mark B · Henderson, NCN9225MSmith Carl L · Danville, KYN9225NOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLFirst renewal noticeN9225VDuncan Mark E · Marlton, NJN9226CLane Community College · Eugene, ORN9226DClf Industries LLC · Thornton, CON9226FLewis University · Romeoville, ILN9226HDebt LLC · Yuma, AZ
Back to AD 90-04-06 R1