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.
N8682YCanepa Joseph H · Baraboo, WIN86834Cardinal Aviation Inc · Murray, KYN86838White Sean Patrick · Fairbanks, AKN8683CDirt Strip LLC · Kalispell, MTN8683VDaniel Shannon B · El Dorado Springs, MON86846Woolard Farms Leasing Inc · Corning, ARN86847Kilbourn James A · Happy Valley, ORN8684CWest Yvonne R · Warrensburg, NYN8684DScott Lonnie L · Nikiski, AKN8684EMotl Gregory C · Humble, TXN86854Moore Planting Co Inc · Cary, MSN86863Pruitt Leland L · Jones, LAN8686YAdvanced Aviation LLC · Midlothian, VAN86872Chupito Sabrocito LLC · Paso Robles, CAN86879Knik Flying Club LLC · Anchorage, AKN8687CMorgigno Daniel A · Mission Viejo, CAN8687VCollum Aviation LLC · Milton, FLN86883High Exposure Inc · Wilmington, DEN86885Mason Peter Trustee · Santa Paula, CAN8688DHarmon Mike D · Mansfield, SDN8688VHawkeye Aviation LLC · Newport, ARN8688YMager Robert R · Quakertown, PAN86890E-Commerce Education Foundation · Tulsa, OKN86892Goodman Jack · Memphis, TNN8689VZacheis Henry M · Fairbanks, AKN8689YBlue Sky Aviators LLC · Winnebago, ILN868BBahrns Phyllis Alyene · Effingham, ILN868KWeber Jennifer R · Bryan, TXN868KFSmith Jason · Calliham, TXN868LHJones Aircraft Co LLC · Cross Plains, TNN868MMUhl Gregory R · Columbus, MSN868PProfessional Training Aircraft LLC · Wilmington, DEN868PKYellow Therapy LLC · Kalispell, MTN868RTMartin John D · Billings, MTN868SAS O W Aviation LLC · Crystal River, FLN868UInter American University Of Puerto Rico · Bayamon, PRN868XGuhr Robert · Stockholm, NJN86901Rudderow Preston Trustee · Anchorage, AKN86911Schneberger Bart A · Nome, AKN86919Latham Ray H · Raymond, WAN8691COrtet Craig A · Etna, WYN8691VAviation Specialists LLC · Wilmington, DEN8691YVan Bladeren John A · Tigard, ORN86928Collum Aviation LLC · Milton, FLN8692CTexas Air And Space Museum Inc · Amarillo, TXN8692DBryan Kirk J · Big Timber, MTN8692VLohr Martin J · Petersburg, AKN8692YTedder Ag Technologies Inc · Walsh, CON86936Lewis Aviation Inc · Wilmington, DEN8693VMichael A Levenhagen · North Fort Myers, FL
Back to AD 90-04-06 R1