AD 98-01-08
Registered aircraft · 35,734
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:98-01-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-01-08')
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:98-01-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-01-08') 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.
N100JDMark Aviation LLC · Kingsport, TNN100JHSonic Aviation LLC · Carrollton, MSN100JPAviation Consulting LLC · Ada, MIN100KFAlbrecht Douglas D · Hobart, INN100KJDrewyor Kenneth · Eaton Rapids, MIN100KSIndependent Aviation Consultants LLC · Sparks, GAN100KWBaldassarre Thomas Anthony · Gillette, NJN100LLPremiere Brand Meats · Shasta Lake, CAN100MDHoppe Joel A · Mankato, MNN100MLMl Aviation LLC · Boulder, CON100MMFarmer Aviation LLC · Milan, MIN100MTDevo Leasing LLC · Park City, UTN100NKLand Air Sea Inc · Chesapeake, VAN100NNDunnair LLC · Panama City, FLN100PCSmokey Bay Air Inc · Homer, AKN100PRKinder Eric Eugene Trustee · Tucson, AZN100PSG & C Property Hc LLC · San Francisco, CAN100PXS & R Air LLC · Amarillo, TXN100PZAeromotors LLC · St James, MON100RBIngraham Donald S · New Bern, NCN100RESchooler Jordan Benjamin · Hummelstown, PAN100RGN100rg LLC · Itta Bena, MSN100SDDivan Jeremy E · Castle Rock, CON100SFSafe Flight Instrument LLC · White Plains, NYN100SLOlson Gordon N · Racine, WIN100SPWright Richard S · Half Moon Bay, CAN100TBAlexander Aviation LLC · Brighton, CON100TGBengtson Todd · Tyler, TXN100TXJones Joseph Clayton · Bossier City, LAN100WMValiair Lc Trustee · Casper, WYN100WSQualitair LLC Trustee · MichelstadtN100XHBiggs Aircraft Inc · Wellston, OKN100XPHeath Darrell L · Houston, TXN100YNEnrique Angulo · San Diego, CAN100YZCay Air LLC · North Palm Beach, FLN100ZPZipjack Inc · Fernandina Beach, FLN100ZZArbuckle George A · Poolville, TXN1011Martin Rex L Trustee · Bakersfield, CAN1011RRegistered aircraftN1011SAfrican American Airlines Inc · Brandon, FLN1012PFly Slc LLC · Salt Lake City, UTN1013LSouthwest Medical Associates Inc · Rockport, TXN1014WAnderson Timothy R · Wilmette, ILN10155Barth James T · Midlothian, TXN1015FInternational Air Services Inc Trustee · Carson City, NVN1015QMayo William J Jr · Reed Point, MTN1015WStanton Thomas Michael · Mcallen, TXN1016BWatts Daniel S · Seal Beach, CAN1016CMartinek Leasing LLC · Bellbrook, OHN1016EHiggins Chris · Sammamish, WA
Back to AD 98-01-08