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.
N886RMFalkenberg Glenn R · Livonia, MIN886RVBazazan Mehrdad D · Fredericksburg, VAN886SACumbass David Shane · Douglas, GAN886SBWhitney Matt Gene · Watertown, SDN886THMock Joseph R · Huntsville, TXN886TVNault Thomas R · Mojave, CAN8870CRegistration Pending · Canal Fulton, OHRegistration pendingN8870DHaumschild Edward E · Marana, AZN8870JAsel LLC · North Charleston, SCN8870NRiley Dennis M · Surry, MEN8871CPlane Fun Inc Tr Trustee · Snellville, GAN8871DSmith James A · Lyle, WAN8871FGarvey Michael · Leesville, SCN8871JJohnson Richard E · Mulberry, FLN8871NCramer Michael L · Rockville Centre, NYN8872CGibbs John D · Victoria, TXN8872DJohnson Robert M · Ada, MNN8872FCameron William Douglas Jr · Lexington, VAN8872GN8872g Holdings LLC · Nashville, TNN8872JPriority Aviation LLC · Lewes, DEN8873CGibbs John D · Victoria, TXN8873DWroe Daniel C · Denton, MDN8874CPleasant Valley Aviation Inc · Bellefonte, PAN8874JMelland Curtis B · Hazen, NDN8874NFisher Tim A · Stockton, MDN88755Old Time Ag Aviation LLC · Bakersfield, CAN8875DBishop Bill I · Cross Plains, TXN8875LMorris Michael · Sarasota, FLN8875NMcclendon Charles Dowel · Lynchburg, VAN8876JDestination Flyer LLC · Memphis, TNN8876LDirks Steven J · Cedar Rapids, IAN8876MLohman Curtis · Shelby, MIN8876YComanche 76y LLC · Waynesboro, VAN8877CBall Fred · College Place, WAN8877DSale Reported · Crystal, MNSale reportedN8877EParrot Flying LLC · San Francisco, CAN8877LGuerra Michael J · Fairhaven, MAN8877YVanhook Orville Richard · Somerset, KYN8878CJones Brian K · Scituate, MAN8878DHamilton Clyde Leon · Forest, VAN8878NCampbell Carl F · Amherst, NHN88793Baggett Donald W · Lake City, FLFirst renewal noticeN8879CMadden John J Jr Co-Trustee · Frostproof, FLN8879EFlickinger Charles P · Hermitage, PAN8879JDaddona John M · Oakville, CTN8879NBesheer Susan Anita · Palm Springs, CAN8879YWelstad Blaine L · Newburg, NDN887BCAustin Aviation LLC · Boise, IDN887CCMr Dent Inc · Manheim, PAN887DMorrow David L · Waterloo, IA
Back to AD 90-04-06 R1