AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N886THMock Joseph R · Huntsville, TXN886TVNault Thomas R · Mojave, CAN886ZJohn Galt LLC · Fairbanks, AKN8870CRegistration Pending · Canal Fulton, OHRegistration pendingN8870DHaumschild Edward E · Marana, AZN8870EGriffin Robert B · Middletown, DEN8870JAsel 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, NYN8871PMq Flights LLC · Missoula, MTN8871WGutierrez Alajandro · Madison, MSN8872CGibbs 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, MDN8873WGarza Reynaldo E · Corpus Christi, TXN8874CPleasant Valley Aviation Inc · Bellefonte, PAN8874JMelland Curtis B · Hazen, NDN8874NFisher Tim A · Stockton, MDN8874PWiebe Aron · Seminole, TXN8875DBishop Bill I · Cross Plains, TXN8875LMorris Michael · Sarasota, FLN8875NMcclendon Charles Dowel · Lynchburg, VAN8875WBryan Greg · Oelwein, IAN8876JDestination Flyer LLC · Memphis, TNN8876LDirks Steven J · Cedar Rapids, IAN8876MLohman Curtis · Shelby, MIN8876PWentworth Douglas G · Simpsonville, KYN8876VBlackburn Aviation Air LLC · Mesa, AZN8876YComanche 76y LLC · Waynesboro, VAN8877CBall Fred · College Place, WAN8877DSale Reported · Crystal, MNSale reportedN8877EParrot Flying LLC · San Francisco, CAN8877LGuerra Michael J · Fairhaven, MAN8877WAvery Aviation LLC · Picabo, IDN8877YVanhook Orville Richard · Somerset, KYN8878CJones Brian K · Scituate, MAN8878DHamilton Clyde Leon · Forest, VAN8878NCampbell Carl F · Amherst, NHN8878WBallard Tim · Roseburg, ORN8879CMadden John J Jr Co-Trustee · Frostproof, FLN8879EFlickinger Charles P · Hermitage, PAN8879JDaddona John M · Oakville, CT
Back to AD 81-18-04 R2