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.
N64575N64575 LLC · Cheyenne, WYN6457DTristar Aviation Services LLC · Hendersonville, TNN6457JHatcher Clifford J · Dallas, GAN6457QRegistered aircraftN6457WWeston Keith M · Ogdensburg, NYN64585Lay Lawrence W · Douglass, KSN6458JFlorida Tectonics Inc · Weirsdale, FLN6458LCentral Texas College · Killeen, TXN6458VWilson David P · Lumberton, TXN6458WJones Larry · Clovis, NMN6459RLogical Drive Inc · Siler City, NCN6459ULinck Market Inc · Little Rock, ARN6459WBillingsley Littleton C Jr · Spicewood, TXN645AWHobart Aviation Inc · Akron, OHN645DBBailey Dennis L · Oakdale, CAN645DDAmes Donald L Trustee · Park City, UTN645DTScenic Mountain Air Inc · Moose Pass, AKN645EJFogelin Eric S · Shasta, CAN645FLRule Charles Y · Mineral Point, WIN645FTFlorida Institute Of Technology · Melbourne, FLN645HChileprop LLC · Mimbres, NMN645KNoyes Jeffery A · Bridgeport, TXN645KAHelocraft Holding Co Inc · Pembroke Pines, FLN645LCJohnston Laura S · Seattle, WAN645NDUniversity Of North Dakota · Grand Forks, NDN645RD&S Development LLC · Spring, TXN645RDVeterinary Surgical Supply (Vss) LLC · Kalispell, MTN645RFHagge Hal E · Eagle River, AKN645SStewart Dennis M · Fernley, NVN645SAGerrish Ronald M · San Antonio, TXN645SDDacy Julia A · Harvard, ILN645SPRegistration Pending · Bennett, CORegistration pendingN64608A S Air LLC · Lantana, FLN6460DVan Wagner Aerial Media LLC · Hollywood, FLN6460LRichmor Aviation Inc · Scotia, NYN6460MHillsboro Aero Academy LLC · Hillsboro, ORN6460QDel Gado Raul L · Victorville, CAN6460UHayes Toby G · Idaho Falls, IDN64611Great North Air LLC · Shelburne, NHN64617Melbourne Flight Training LLC · Melbourne, FLN6461CTripacer Strategic Consulting LLC · Dover, DEN6461QGanos Christ · Brookfield, WIN6461RBetsy N6461r LLC · Novato, CAN6461VRegistered aircraftN6461WOverstreet Aviation LLC · Sunray, TXN6462CA&J Aircraft Leasing Inc · Burlington, CON6462DN2893e LLC · Reno, NVN6462JRentz Bradford C · Baxley, GAN6462QPlummer Joshua · Fort Mill, SCN6462RGoodens Floorcovering Inc · Tallapoosa, GA
Back to AD 90-04-06 R1