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.
N4918CJetblack Ventures LLC · Bakersfield, CAN4918FBarnes Charles G · Louisville, KYN4918HMarks Aviation Corp · Beverly Hills, CAN4918JWoolley Charles K · Clarksville, TNN4918LAthene Solutions LLC · Coral Springs, FLN49191Hillsboro Aero Academy LLC · Hillsboro, ORN49194Hillsboro Aero Academy LLC · Hillsboro, ORN49197Wilt Aviation Consulting LLC · Sebastian, FLN49199Wygant Amanda N · Copper Center, AKN4919FTice Denzil · Farmville, VAN4919LCroft Jeffrey W · Tennessee Colony, TXN4919PRiggs Charles A · Pembroke Pines, FLN491BGShogren Coleman D · Yakima, WAN491CMMottinger Casey P · Elizabeth, CON491DKey City Fliers · Maquoketa, IAN491ETKennebeck Ronald C · Johnston, IAN491FLWashington Fliers Inc · Pantego, NCN491GShelton Christopher O · Aubrey, TXN491JPGuy Jeffrey · Centerburg, OHN491MABelle Casa Sport LLC · Tarpon Springs, FLN491NDChristiansen Aviation LLC · Wilmington, DEN491PDAir Ventures Awaits LLC · Middletown, DEN491SPLittle Rock Lsa Leasing And Rental LLC · Searcy, ARN491WSDhs Operations LLC · Wilmington, DEN49202Skylogix Aircraft LLC · La Verne, CAN49208Graf Eugene · Bozeman, MTN4920GEye Candy Aviation LLC · Jacksonville, FLN4920LLvc Air LLC · Allen, TXN49215Dukelow Thomas W · Bad Axe, MIN4921JHerdrich Sean D · Manchester, IAN4921LBarrett Howard L · Austinville, VAN4921NFulmer Loren · Anna Maria, FLN4921VFrumkin Mark Steven · Pittsburgh, PAN49226Parrish Aviation Flight Academy LLC · Southlake, TXN4922BAvcorp Holdings Inc · Jackson, MIN4922DD Gordon Aviation Inc · La Jolla, CAN4922GBishop Air LLC · Elk Grove, CAN4922JOpat Randall J · Port Saint Lucie, FLN4922LSpanjer William H · Pine Bush, NYN4922TShamseldin Nathan · Buckley, WAN4922VHhd Aviation LLC · Hamilton, OHN49230US Flight Academy International Inc DBA · Post, TXN4923DHarrier Aviation LLC · South Saint Paul, MNN4923LDevrnja Aero LLC · Louisville, TNN4923ZWeigel Martin C · Valley City, OHN49249Krawczak Kyle C · Littleton, CON4924JCarper Clyde S · New Port Richey, FLN4924ZGlover Thomas B · Marana, AZN49256Bais Donald H · College Place, WAN4925FA S Air LLC · Lantana, FL
Back to AD 90-04-06 R1