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.
N4925GSchwenker David W · Queensbury, NYN4925ZKopacz Thomas H · Glen Flora, WIN49260Youth Aeronautics Education Foundation · Mattaponi, VAN49261Salem Oregon Flight Training LLC · Salem, ORN49268Fox John E · Boonville, CAN4926LRedden John V · Mooresville, NCN49276Hillsboro Aero Academy LLC · Hillsboro, ORN4927BAviation Capital Management LLC · San Jose, CAN4927CRegistration Pending · Helena, MTRegistration pending, pending cancellationN4927DGreenville Flight LLC · Greer, SCN4927LProfessional Plastic Solutions LLC · Irving, TXN49285Fullerton Airport Pilot Association · Fullerton, CAN49288Wisconsin Aviation Inc · Watertown, WIN4928BWings Over Texas Holdings LLC · Denton, TXN4928EAce Of Spades Aviation LLC · Las Vegas, NVN4928LTwo8lima Llp · Bryan, OHN49292Johnson Scott W · Saline, MIN4929JBurnett Robert E · San Leandro, CAN4929LMaak Air LLC · Wahoo, NEN4929ZDennis Robert · Rosamond, CAN492ACRobinson Mark A · Carson City, NVN492BNTurner Harvey Jr · Raleigh, NCN492DSSkywest Leasing Inc · St George, UTN492FLMcknight Anna Mae · Vernon, TXN492JBBorke Michael F · Charleston, SCN492LGSunday Punchers LLC · Monrovia, INN492NDChristiansen Aviation LLC · Wilmington, DEN492RDOsborne Paul B · Ocala, FLN492RVRegistered aircraftN492SFSnohomish Flying Service Inc · Snohomish, WAN492SPChristiansen Aviation LLC · Wilmington, DEN492WAirplane Adventures LLC · Palos Heights, ILN492WPAngel Aviation Inc · Peoria, AZN492XMcdonald Stuart D · Phoenix, AZN49305Everything Pitts LLC · Queen Creek, AZN49306Mercer Mark E · Aurora, CON49307Lutes David W · Berryton, KSN49309Newton Thomas L Jr · Fredericksburg, VAN4930BSkyranch Knoxville Youth Inc · Knoxville, TNN4930HSantillan Hannah M · Belgrade, MTN4930LG Salisbury & Associates Inc · Prescott, AZN4930UUniversity Of Oklahoma · Norman, OKN49312Boyd Timothy · East Point, KYN49314Losacker Matthew S · Chandler, AZN49315Morphew Ben · Mckinney, TXN49319Anderson Richard P · De Leon Springs, FLN4931BWojtowicz Tomasz · Bronx, NYN4931LThrust Spear Of Tampa LLC · Tampa, FLN4931ZThurmond Kenneth · Eastover, NCN49324Vfr Ltd · Wilmington, DE
Back to AD 90-04-06 R1