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.
N7870VWilliams Danny L · Carson, CAN7870WGaydon Jesse A · Sharpsburg, GAN7871Aderman Nick · Palmer, AKN78710Flying 64th Inc · Oak Ridge, TNN78711Swartwood Thomas · Everson, WAN78713Hamilton Robert M · Saint Louis, MON78716Rhodes Sanford E · Odessa, TXN78718Aircraft 1821 LLC · North Charleston, SCN7871VEdwards Eddie E · Borger, TXN7871WWisdom Gary A · Farmersville, TXN7871YDow Jeff W · Port Hadlock, WAN78721Aquino Rogelio M · Cliffside Park, NJN78729Copper Country Flyers Inc · Oconto, WIN7872GAmerican Classic Flying Club LLC · Waterville, MEN7872VMac Residential Services LLC · Gravette, ARN7872WHeard Derrick A · Greensboro, NCN78733Garden Spot Flyers · Manheim, PAN78735Holt Bill R · Ralph, SDN7873PKirtley Kevin R · Boise, IDN78747Green Matthew M · Turlock, CAN7874DSipes Greg A · North Pole, AKN7874GLa Porta John R · Des Moines, WAN7874VHague Collin J · Newark, DEN7874WLink John P · West Milford, NJN78757Hooten Bonnie Bryan · Tifton, GAN7875DUnited States Department Of Interior · Boise, IDN7875GRegistration Pending · Helena, MTRegistration pending, pending cancellationN7875P3 Commanches Aviation LLC · Williamston, SCN7875VSmokovitz Daniel J · Brighton, MIN7875YDodson Carl F · Jasper, INN78760Jakus Matthew Thomas Trustee · Parowan, UTN78763Steve'S Landavator Service LLC · Oley, PAN78766Boyle Dale L · Woodward, OKN7876PCrouse Gregory T · Napa, CAN7876VMooneyes LLC · White Oak, TXN78772Egrass Peter M · Anchorage, AKN7877PMiller Kenneth · Jennings, LAN7877SLocker Don D · Muleshoe, TXN7877WShields John R · Chester, NHN78785Peck John M · Melrose, MTN78787Largent Walter S · Fairbanks, AKN78789Hooper Dan B · Zanesville, OHN7878EWarner Colin D · Hillsboro, ORN7878V7878 Victor Inc · Tampa, FLN78797Allen Stephanie R · Mukilteo, WAN78799Aerolanding LLC · Enterprise, ALN7879GComposite Systems Inc · Lake Worth, FLN7879HLorence Joshua J · Soldotna, AKN7879PKeenan Matthew J · Clearwater, FLN7879VRowan James T Jr · Silver City, NM
Back to AD 81-18-04 R2