AD 90-15-15 R1
Registered aircraft · 826
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-15-15-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-15-15-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-15-15-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-15-15-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.
N233DPProp 2 Fox LLC · Hudson, OHN234BAJohnson Alan Lee · Pikeville, KYN234HBLentini Christopher · Ardmore, OKN238DMCopeland Gary L · Williamsburg, MIN23PZInternational Air Services Inc Trustee · Carson City, NVN240AKPhoenix Leasing LLC · Menomonee Falls, WIN240RJHavabaaz Aviation LLC · Great Falls, VAN245BCBambach Gregory Alan · Manistique, MIN245SFLindley Robert F III · Williamson, GAN2468WGodwin Gerald · Orange, TXN246KKeeton James H · Atlanta, GAN247MAWanda Collins Professional Pilot Services LLC · College Station, TXN248MAStick Back Aviation Inc · Le Roy, NYN249MAQueen City Flying LLC · Helena, MTN24BYOur Sky LLC · Woodinville, WAN24SZJordan James David · Helena, ALN2502ZByrne Gary W DBA · Georgetown, INN2505ZStratton Robert Stephen · Boulder, CON2509ZKovach Kim A · Ocala, FLN2512ZPlane Old Fun LLC · Mckinney, TXN2523ZBchr Aviation LLC · Boerne, TXN2524ZEgan Brian M · Saint Charles, ILN2525SJbird Aviation LLC · Elizabeth City, NCN2538ZSnell Marion Lea · Ackerly, TXN253CAJtv Enterprises LLC · Painesville, OHN2542ZGreenway Jonathan J · Frederick, MDN2543ZSchindler Jason D · Oneill, NEN2549ZBronson Aviation Industries LLC · Sharpsburg, GAN254VVBoney Grady · Rhine, GAN255BRRice Bob J · Corning, ARN255TJackson Travels LLC · Quitman, TXN2561ZMcbride Steve · Shamong, NJN2574ZKeegan Ace LLC · Tampa, FLN2586ZFernandez John III · Cape Canaveral, FLN2599ZAirborne Images Inc · Encino, CAN25NWFlynow Aviation LLC · Asheville, NCN2626SDelta Aero LLC · Sarasota, FLN262ACLavelle Jeffrey · Kenmore, WAN263MAMacair Aviation LLC · Xenia, OHN2654ZAlbij3 LLC · Milton, FLN2656ZChesebro Brian S · Oro Valley, AZN265CAZacherl Randall L · Indiana, PAN265MATrevathan Max Tyler · Braggadocio, MON2663ZVaccaro Glen J · Trinidad, CON267GSArnold Airplane LLC · North Branch, MNN267JMomentum Foundation Inc · Tullahoma, TNN2687ZSchaefer Richard T · Marble Falls, TXN26BYSnohoacro LLC · Mukilteo, WAN26PFPucciariello Alexander A · Haskell, NJN2711ZSchmelzer Thomas D · Lino Lakes, MN
Back to AD 90-15-15 R1